>-Original Message-
>From: Johan De Meersman [mailto:vegiv...@tuxera.be]
>Sent: Monday, June 06, 2011 12:57 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Timestamp value
>
>
>I may be mistaken, but isn't UTC pretty much GMT if you don'
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 compa
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_ti
timestamp value
#--
#--
#--
#--What's the largest possible timestamp value before it rolls over?
#--I'm trying to figure out what's the best way to do the following. I
#--have a table that has these three fields in it:
#--
#--priority int(3)
#--end_time timestamp(14)
#-
What's the largest possible timestamp value before it rolls over?
I'm trying to figure out what's the best way to do the following. I
have a table that has these three fields in it:
priority int(3)
end_time timestamp(14)
start_time timestamp(14)
NOTE: only
