List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 6 2011 4:56pm
Subject:Re: Timestamp value
View as plain text  
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
Thread
Timestamp valueJerry Schwartz6 Jun
  • Re: Timestamp valueJohan De Meersman6 Jun
    • RE: Timestamp valueJerry Schwartz6 Jun