Posted by James on 01/03/07 13:50

I am attempting to write a statement for inserting a current timestamp into
a MySQL database. The MySQL field is of type datetime. The statement I
first tried to generate a value for the field is:

date("Y-m-d H:i:s")

Then, I tried:

gmdate("Y-m-d H:i:s")

Both resulted in a timestamp in the local timezone. What I wish to do is
place the timestamp into UTC, so when later displayed in a browser it can be
converted to a local TZ.

Thanks for your help!
James

[Back to original message]