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"