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
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.
Suggestions always welcome :)