Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jason Wong
On Thursday 14 March 2002 18:11, Jon Haworth wrote: > > Unixtimestamp from Mysql :1016679600 > > Unixtimestamp from PHP :953699601 > > y this much difference? > > A PHP timestamp is the number of seconds since 1st Jan 1970 To be pedantic, in PHP it is time() > A MySQL UNIX_TIMESTAMP is the dat

Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jason Wong
On Thursday 14 March 2002 18:03, Balaji Ankem wrote: > Hi, >UNIX_TIMESTAMP(2002-03-21 08:30:00) and >mktime(2002,03,21,08,30,00) equal or not? > > But both are same timestamp..but returning values are > different.y? > > Unixtimestamp from Mysql :1016679600 >

Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Rasmus Lerdorf
>UNIX_TIMESTAMP(2002-03-21 08:30:00) and >mktime(2002,03,21,08,30,00) equal or not? Careful, 08 != 8 A leading 0 indicates an octal number in PHP. Also, you have the arguments to mktime() completely messed up. It is hour, minute, second, month, day, year. 2002 is a strange-loo

RE: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Jon Haworth
> Unixtimestamp from Mysql :1016679600 > Unixtimestamp from PHP :953699601 > y this much difference? A PHP timestamp is the number of seconds since 1st Jan 1970 A MySQL UNIX_TIMESTAMP is the date in MMDDHHMMSS format. Cheers Jon -- PHP General Mailing List (http://www.php.net/) To uns

[PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()

2002-03-14 Thread Balaji Ankem
Hi, UNIX_TIMESTAMP(2002-03-21 08:30:00) and mktime(2002,03,21,08,30,00) equal or not? But both are same timestamp..but returning values are different.y? Unixtimestamp from Mysql :1016679600 Unixtimestamp from PHP :953699601 y this much