NYCPHP Meetup

NYPHP.org

[nycphp-talk] Selecting unix timestamp from MySQL (3.x) datetime field

John Lacey jlacey at att.net
Thu Aug 12 17:56:47 EDT 2004


John Corry wrote:

> I wish this were a DATE_FORMAT option...
> 
> How do I turn a MySQL DATETIME field (0000-00-00 00:00) into a Unix
> timestamp?
> 
> Strtotime() choked.

a MySQL function:

UNIX_TIMESTAMP('0000-00-00 blah...')

John




More information about the talk mailing list