Re: Comment on timezone and interval types - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Comment on timezone and interval types
Date
Msg-id 20041029174620.GA28827@wolff.to
Whole thread Raw
In response to Re: Comment on timezone and interval types  (Guy Fraser <guy@incentre.net>)
Responses Re: Comment on timezone and interval types  (Stuart Bishop <stuart@stuartbishop.net>)
List pgsql-general
On Fri, Oct 29, 2004 at 11:14:31 -0600,
  Guy Fraser <guy@incentre.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.

pgsql-general by date:

Previous
From: "J. Michael Crawford"
Date:
Subject: Re: UTF-8 -> ISO8859-1 conversion problem
Next
From: Tom Lane
Date:
Subject: Re: tasks