|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #13187 Concerning jdtounix() function
Submitted: 2001-09-06 19:18 UTC Modified: 2002-05-25 06:43 UTC
From: studiobl at mageos dot com Assigned:
Status: Closed Package: Calendar related
PHP Version: 4.0.6 OS: Linux Redhat 7.1
Private report: No CVE-ID: None
 [2001-09-06 19:18 UTC] studiobl at mageos dot com
It's not unresolvable but it must be known :

in PHP :
returns a number of seconds sinc an origin (here we call it A)

but in MYSQL :
UNIX_TIMESTAMP(today at 00:00:00)
returns A minus 7200 seconds

that's a difference of 2 hours !

in fact when you do jdtounix(today) it more like jdtounix(today at 02:00:00)....


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2001-09-07 03:55 UTC]
what timezone are you in ?
 [2001-09-07 07:29 UTC] studiobl at mageos dot com
I m in FRANCE(Paris) GMT or GMT+1 I think
 [2001-09-07 07:48 UTC]
France is GMT+2 during summer and GMT+1 during winter

 [2001-09-07 07:55 UTC]
so jdtounix returns localtime while
mysql unix_timestamp returns GMT
 [2001-09-07 08:00 UTC] studiobl at mageos dot com
By the way I don't know why there would be a link
between my system date and those operations ???

Friday 2001-09-07 -> jd=2462160

jdtounix(2462160)=999820800 sec

UNIX_TIMESTAMP('2001-09-07 00:00:00')=999813600 sec

but : UNIX_TIMESTAMP('2001-09-07 02:00:00')=999820800 sec

Is it clear ?

 [2001-09-07 08:02 UTC] studiobl at mageos dot com
I havn't seen the last comment I was editing, 
perhaps that's an explanation but it must be noticed
in the function help...
 [2002-05-25 06:43 UTC]
Updated documentation for jdtounix > closing.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Jun 18 06:01:31 2024 UTC