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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
