Timezone - Problem

RT Users
1

It seems to me that RT converts date/time information to GMT before
storing it into the Mysql-database.
Is there a way to prevent this ?

2

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)

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations
3

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)