Skip site navigation (1) Skip section navigation (2)

Re: timestamp with time zone a la sql99

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: timestamp with time zone a la sql99
Date: 2004-10-25 19:40:57
Message-ID: 20041025194057.GA26356@wolff.to (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Oct 25, 2004 at 21:18:52 +0200,
  Dennis Bjorklund <db(at)zigo(dot)dhs(dot)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.

In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2004-10-25 19:49:31
Subject: Re: code question: storing INTO relation
Previous:From: Tom LaneDate: 2004-10-25 19:35:04
Subject: Re: timestamp with time zone a la sql99

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group