[prev in list] [next in list] [prev in thread] [next in thread] 

List:       rt-devel
Subject:    Re: [Rt-devel] Store dates in DB not in UTC?
From:       Vick Khera <vivek () khera ! org>
Date:       2010-01-28 21:19:23
Message-ID: 2968dfd61001281319j4c48bc7fm33c9ab891dcfb220 () mail ! gmail ! com
[Download RAW message or body]

On Thu, Jan 28, 2010 at 3:42 PM, Peter C. Lai <peter@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
suspect.
_______________________________________________
List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
[prev in list] [next in list] [prev in thread] [next in thread]