 | | | Timezone query similiar to pgsql | Timezone query similiar to pgsql 2005-09-09 - By Dan Nelson
Back
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@(protected)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
|