Date a Time

[NZ_Kiwi]

Hi All,

this may be real easy!! i want the date and time to add to a cell when i add a new line to my sql database.. my server is us based and i want all time to be nz times

[Weedpacket]

What does your database server's documentation say about timezones?

[ccgorman]

I think you will need to use the DATETIME attribute rather then timestamp to control the date and time, given your server is in a different timezone.

ALTER TABLE tablename ADD timeadded DATETIME;

You can then use the mktime function to edit the date and time before insertion into the database.

http://uk.php.net/manual/en/function.mktime.php