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 YYYYMMDDHHMMSS 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

Reply via email to