[rt-users] Time Zone - MySQL only.

[Shannon Pedersen]

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