Re: Daylight savings - Mailing list pgsql-general

From Tom Lane
Subject Re: Daylight savings
Date
Msg-id 1731.989015258@sss.pgh.pa.us
Whole thread Raw
In response to Daylight savings  (Justin Clift <aa2@bigpond.net.au>)
List pgsql-general
Justin Clift <aa2@bigpond.net.au> writes:
> This is so we can have certain types of data which are stored in the
> database as localtime, updated to still be correct during DST and
> after.

This sounds awfully ugly.  Can't you design the data representation so
that no such kluge is needed?  Most of the PG date/time types store in
GMT internally, so that there shouldn't be a problem...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: underlying structure: varchar vs. text
Next
From: Tom Lane
Date:
Subject: Re: semi-stupid question (index on OID)