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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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