Re: timestamp with time zone a la sql99 - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject Re: timestamp with time zone a la sql99
Date
Msg-id Pine.LNX.4.44.0410252019320.2015-100000@zigo.dhs.org
Whole thread Raw
In response to Re: timestamp with time zone a la sql99  (Josh Berkus <josh@agliodbs.com>)
Responses Re: timestamp with time zone a la sql99
List pgsql-hackers
On Mon, 25 Oct 2004, Josh Berkus wrote:

> Hmmm ... well, does the spec specifically prohibit DST, or just leave it
> out?

It doesn't discuss it. According to the spec a timestamp with time zone is 
a UTC value + a HH:MM offset from GMT. And intervals in the spec is either 
a year-month value or a day-time value. One can only compare year-month 
values with each other and day-time values with each other. So they avoid 
the problem of the how many days is a month by not allowing it.

The spec is not a full solution, it's also not a useless solution. I'm
happy as long as the spec is a subset of what pg implements. If not then I
would like to be able to have both but with different names or something
similar (but I think that should not be needed).

-- 
/Dennis Björklund



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamp with time zone a la sql99
Next
From: Josh Berkus
Date:
Subject: Re: timestamp with time zone a la sql99