[rt-users] Time Zone - MySQL only.
Bruce Campbell
bruce_campbell at ripe.net
Wed Feb 27 16:28:33 EST 2002
On Wed, 27 Feb 2002, Shannon Pedersen wrote:
> 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
More information about the rt-users
mailing list