[Rt-devel] Store dates in DB not in UTC?

Jesse Vincent jesse at bestpractical.com
Thu Jan 28 15:25:12 EST 2010




On Wed 27.Jan'10 at 17:30:15 +0200, Agnislav Onufrijchuk wrote:
> Hi all.
> 
> rt 3.8.5
> 
> Is it possible to modify subroutines that control dates to store dates 
> in DB not in UTC but in local server's timezone?

I would expect that this would be a fair amount of work. And it would
mean that your database can no longer be easily moved to another
timezone. Additionally, it means that you start to have to think about
daylight savings time for tickets in your database.

> It seems that too many things depend on UTC in DB. Am I right?

You are correct.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20100128/4b5eebd2/attachment.pgp 


More information about the Rt-devel mailing list