List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 10 2005 2:52am
Subject:Re: Timezone query similiar to pgsql
View as plain text  
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
Thread
Timezone query similiar to pgsqlTerence10 Sep
  • Re: Timezone query similiar to pgsqlDan Nelson10 Sep