[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