Time Zone - MySQL only

RT Users
1

I have an odd problem that I’m not sure how to remedy. I’ve looked
through the archives but nothing addresses my particular situation.

I’m on PST time; the time is correct on my server when I use “date”, he
time is correct in MySQL when I use “select now();” and the time is
correct in RT when you display and email tickets.

The problem? The actual time getting recorded in MySQL as the "Started"
field is in GMT! I didn’t realize this until I started using the Open
Tickets addon that includes this field in the email, and the timestamps
were off. When I went investigating, it turned out that the actual time
being recorded in MySQL is wrong, although it appears properly
everywhere else.

Any thoughts?

Thanks much,

Shannon Pedersen

2

The problem? The actual time getting recorded in MySQL as the “Started”
field is in GMT! I didn’t realize this until I started using the Open
Tickets addon that includes this field in the email, and the timestamps
were off. When I went investigating, it turned out that the actual time
being recorded in MySQL is wrong, although it appears properly
everywhere else.

Your problem would appear to be in the Open Tickets addon, which is not
adjusting the time returned from SQL for your local timezone.

RT’s core, by design, stores all time-related information in GMT, and
makes local timezone adjustments when performing time-based queries or
displaying times.

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