On Tue, Aug 24, 2004 at 03:16:30PM -0400, Shahbaz Javeed wrote:
> 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
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"
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2004-08-24 19:46:17|
|Subject: Re: AT TIME ZONE |
|Previous:||From: Shahbaz Javeed||Date: 2004-08-24 19:16:30|
|Subject: Re: AT TIME ZONE|