RE: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()
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 unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()
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-looking hour. -Rasmus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()
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 Unixtimestamp from PHP :953699601 y this much difference? The arguments you're giving to mktime are in the wrong order. mktime (hour, minute, second, month, day, year [, is_dst]); -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* 186,282 miles per second: It isn't just a good idea, it's the law! */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hi what is diff. Between mktime() and UNIX_TIMESTAMP()
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 MMDDHHMMSS format. Not correct. In MySQL UNIX_TIMESTAMP also returns the number of seconds since the unix epoch. Thus: php -- time(); mysql -- select UNIX_TIMESTAMP(); should both return the same value; -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* In the next world, you're on your own. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
