note 21386 deleted from function.date by sniper
| From: | sniper@php.net | Date: | Sat, 11 Oct 2003 16:49:31 +0000 |
| Subject: | note 21386 deleted from function.date by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-58253@lists.php.net to get a copy of this message | ||
Note Submitter: sql@lightningxp.com
----
Looking into the mySQL manual I found that as already stated PHP and mySql have tow different time
stamping numbers. PHP is UNIX timestamp: seconds in GMT since 1970.01.01 00:00:00, there is a
function in mySql that supports converting SQL timestamp to unix.
select UNIX_TIMESTAMP('1997-10-04 22:23:00');
will return a number PHP likes for its date timestamp.
Hope this helps
Greg