From: Johan De Meersman
Date: June 6 2011 4:56pm
Subject: Re: Timestamp value
List-Archive: http://lists.mysql.com/mysql/225183
Message-Id: <6ec1d52c-9689-4fa9-996a-88677bf4fe87@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


I may be mistaken, but isn't UTC pretty much GMT if you don't want subsecond precision? Set your server's timezone to GMT and you should get what you want.

----- Original Message -----
> From: "Jerry Schwartz" <jerry@stripped>
> To: mysql@stripped
> Sent: Monday, 6 June, 2011 5:10:22 PM
> Subject: Timestamp value
> 
> When you UPDATE a record, a timestamp field (`t`) is set to the
> current time
> in the time zone given by @@time_zone, correct? That will usually be
> the local
> time.
> 
> If somebody in another time zone needs to compare `t` against //their
> own//
> local time, they need to use
> 
> CONVERT_TZ(`t`,'my_local_time zone','their_local_time_zone`)
> 
> Am I right?
> 
> So, what if they do not know my local time zone? Is there a way to
> create a
> timestamp field that is always in UTC? I don't think there is,
> without using a
> trigger.
> 
> Am I right about that?
> 
> 
> 
> Regards,
> 
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
> 
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@stripped
> Web site: www.the-infoshop.com
> 

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel