[plug] php4 mysql date functions.

Leon Brooks leon at brooks.fdns.net
Mon Dec 9 21:44:35 WST 2002


On Monday 09 December 2002 06:17 pm, shayne oneill wrote:
> I need to insert dates and times into a datetime field in a mysql database,
> and get a sensible string back on retrieval.

IIRC, MySQL expects something like 'YYYY-MM-DD HH:MM:SS', so try inserting 
date ('Y-m-d H:i:s', $stamp) - you might also need a timezone (not sure on 
this) lest it be assumed to mean GMT.

Cheers; Leon



More information about the plug mailing list