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
> If somebody in another time zone needs to compare `t` against //their
> 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
> Am I right about that?
> 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