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

Vick Khera vivek at khera.org
Thu Jan 28 16:19:23 EST 2010

On Thu, Jan 28, 2010 at 3:42 PM, Peter C. Lai <peter at simons-rock.edu> wrote:
> Every developer worth their consulting fee will tell you to always store
> dates in POSIX or ISO-8601 UTC format and use timezone offsets to calculate
> "local time" from these dates for user display. TZ conversion code is

Or, use a database that knows how to do this for you.  TIMESTAMP WITH
TIMEZONE is the only usable way to store timestamps and have them mean
anything...  but RT is DB agnostic, so cannot take advantage of this I

More information about the Rt-devel mailing list