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

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

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 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 date in