In the last episode (Sep 10), Terence said:
> Does MySQL have something similiar to
>
> SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
>
> I need to handle the timestamp in the database. Previous posts and some
> googling suggests it should be in the PHP layer which is not an option
> for me.
> My users come from various timezones, and so I plan to store everything
> in GMT (server time) and select the time based on their timezone
> preference which is stored in a user preference table.
Start at http://dev.mysql.com/doc/mysql/en/time-zone-support.html and
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
(especially CONVERT_TZ() ).
--
Dan Nelson
dnelson@stripped
