[rt-users] Incorrect time in mysql db?

Jesse Vincent jesse at bestpractical.com
Tue May 27 00:11:05 EDT 2003


All times inside RT are stored as GMT.


On Tue, May 27, 2003 at 02:04:46PM +1000, Gonzalo Servat wrote:
> Hi All
> 
> My apologies if this has been discussed before. I google'd and searched the 
> mailing list archives and couldn't find an answer to my problem.
> 
> I'm running RT 3.0.0. I have the Timezone setting set in RT_Config.pm to 
> Australia/Sydney, and all the times in the RT webUI are correct. However, 
> for some strange reason the times in the actual MySQL DB are totally wrong. 
> For example, I replied to a ticket and the RT webUI shows 13:47:09 which is 
> correct, but in the 'Transactions' table of the RT database shows 
> '03:47:09'. It seems to me like something in the process is set to GMT 
> (should be GMT+10). Any ideas?
> 
> TIA!
> 
> Regards,
> Gonzalo.
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the rt-users mailing list