Time Differences

RT Users
1

When we are viewing the web interface of RT, we see the time submitted
as being accurate. However, when we do an export to spreadsheet, we are
seeing the time being different by several hours. We check the DB and
see that it says the same as the export. However, this appears to be
different than the system time.

Is the RT backend use UTC and the web interface convert that time to
localtime? Is there a way to get the exports to relate the same time as
the web interface?

Thanks,

Ryan Roland

Network & Security Administrator
Information Technology
Division of Recreational Sports
Indiana University

2

Hi, I had the same question a few days ago and Ruslan told me that the RT db
uses GMT. I have not tried the exports yet but if I can do this, I will let
you know

Best Regards,
Ravin Mathoora-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Roland, Ryan
M
Sent: 20 July 2005 23:06
To: RT Users group
Subject: [rt-users] Time Differences

When we are viewing the web interface of RT, we see the time submitted
as being accurate. However, when we do an export to spreadsheet, we are
seeing the time being different by several hours. We check the DB and
see that it says the same as the export. However, this appears to be
different than the system time.

Is the RT backend use UTC and the web interface convert that time to
localtime? Is there a way to get the exports to relate the same time as
the web interface?

Thanks,

Ryan Roland

Network & Security Administrator
Information Technology
Division of Recreational Sports
Indiana University
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

3

Is there a config flag or something I can set that will make RT store
the ticket using system time instead of GMT?

Or is there a way to get the export function to use the locale to modify
that datetime as it exports it?

This way we won’t have to fight/alter/manipulate anything when we try to
export out of it for reporting purposes.

Thanks,

Ryan Roland

Network & Security Administrator
Information Technology
Division of Recreational Sports
Indiana University