Re: AT TIME ZONE

On Tue, Aug 24, 2004 at 03:16:30PM -0400, Shahbaz Javeed wrote:

People,

> I wonder whether this TODO item also covers cases such as inserting
> into a table where one field is time in the local timezone and the
> other is time in GMT.  Not sure if such a thing is desirable or even
> possible (in the SQL standard).  The syntax I'm imagining feels pretty
> awkward.

I wonder instead if it will be possible to store a timestamp without
timezone in one field, and a timezone in another field.  So I can get
back a timestamp at the second-field timezone.

I know this works for abbreviations, but this doesn't help me solve the
problem at DST boundaries (abbreviations change at that point).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The ability to monopolize a planet is insignificant
next to the power of the source"