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
(especially CONVERT_TZ() ).