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

From Bruno Wolff III
Subject Re: timestamp with time zone a la sql99
Date
Msg-id 20041025194057.GA26356@wolff.to
Whole thread Raw
In response to Re: timestamp with time zone a la sql99  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
On Mon, Oct 25, 2004 at 21:18:52 +0200, Dennis Bjorklund <db@zigo.dhs.org> wrote:
> On Mon, 25 Oct 2004, Josh Berkus wrote:
> 
> > Hour/Minute/Second/ms
> > Day/Week
> > Month/Year
> 
> This is embarrasing. I'm still a bit confused :-)
> 
> The standard treat days as a separate entry, it does not assume that a day 
> is 24 hours. It restricts the hour field to the interval 0-23 so one can 
> never have something like 25 hours. So it does not need to worry about how 
> many days that translate to.
> 
> And why do we need weeks also?

For convenience. Just like years are a group of months, weeks are a group
of days.


pgsql-hackers by date:

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