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" <je...@gii.co.jp> > To: mysql@lists.mysql.com > 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: je...@gii.co.jp > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org