[rt-users] Timezone - Problem

Frederic Gobin frederic.gobin at mindmatics.de
Mon Apr 29 11:42:05 EDT 2002


I found an other way :
I replaced the "now()"-function in the selectd statement with
'date -u +"%Y-%m-%d %H:%M:%S"'

Frederic Gobin

Bruce Campbell wrote:
> On Mon, 29 Apr 2002, Frederic Gobin wrote:
> 
> 
>>It seems to me that RT converts date/time information to GMT before
>>storing it into the Mysql-database.
> 
> 
> Yes.  This is the intended behaviour; store times without a timezone
> offset, so when your local timezone changes (eg, daylight savings time),
> the times in the database are still correct.
> 
> 
>>Is there a way to prevent this ?
> 
> 
> Not without significant RT-foo.  (You don't want to change this)
> 







More information about the rt-users mailing list