[rt-users] RT 3.6.5 transactions created in wrong timezone....
Emmanuel Lacour
elacour at easter-eggs.com
Mon May 26 11:02:37 EDT 2008
On Tue, May 27, 2008 at 12:55:22AM +1000, Les Stott wrote:
>
>
> Jesse Vincent wrote:
> > In the UI or in the database? RT stores all timestamps in GMT in the
> > database.
> >
> >
> In the UI it looks fine. Its in the DB that it is out of whack.
>
> Checking database tables via phpmyadmin shows Transactions.Created to be
> in wrong timezone whereas the UI shows them fine.
>
> The script i am using is below for reference......
>
Like Jesse said, times are stored as GMT in the DB, so if you access the
DB directly without using the RT API, you have to convert times to your
timezone manually in your script.
More information about the rt-users
mailing list