Re: timezone locale fun

From: markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: timezone locale fun
Date: 2002-11-07 16:22:24
Message-ID: 3DCA9340.1BCB7529@telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

TJ wrote:

> I'm making a SWAG that my only real solution is to store both the
> local timestamp (uncorrected) *and* the (standard) UTC timestamp from
> my clients. This way, I can safely calc the endurance using one
> column, and report the endpoints using another column.
>
> Anyone see any holes in this? Any other good suggestions that don't
> require absurd amounts of complexity?

Yeah- this sort of thing /is/ fun, isn't it? :-) Frankly I don't think
that there's a "correct" solution (look as the vituperation surrounding
MS timezone handling) and the more info you store when the data is saved
the better since that gives you the option of going back and re-running
reports if somebody tells you the goalposts have moved. I store all data
in GMT with info in each record so that it's traceable, gross timezones
can obviously be handled easily in the query but the final application
of DST correction is handled in the client apps (written in Delphi but
using embedded scripting and interpolation).

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or
colleagues]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2002-11-07 16:23:31 Re: Inserting streamed data
Previous Message Richard Huxton 2002-11-07 16:16:09 Re: Q!