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

Re: Comment on timezone and interval types

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Guy Fraser <guy(at)incentre(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Comment on timezone and interval types
Date: 2004-10-29 17:46:20
Message-ID: 20041029174620.GA28827@wolff.to (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Oct 29, 2004 at 11:14:31 -0600,
  Guy Fraser <guy(at)incentre(dot)net> wrote:
> 
> 1 day should always be calculated as 24 hours, just as an hour
> is calculated as 60 minutes...

If you want 24 hours you can use 24 hours. Days are not constant length,
just like months aren't constant length.

> Since interval does not store an actual time range, it is not sensitive to
> daylight savings.

When inetervals are added or subtracted from timestamps there is an actual
time range which makes DST transitions relevant.

In response to

Responses

pgsql-general by date

Next:From: J. Michael CrawfordDate: 2004-10-29 17:47:37
Subject: Re: UTF-8 -> ISO8859-1 conversion problem
Previous:From: J. Michael CrawfordDate: 2004-10-29 17:19:39
Subject: Re: UTF-8 -> ISO8859-1 conversion problem

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