Re: '1 year' = '360 days' ????

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: '1 year' = '360 days' ????
Date: 2004-10-28 17:20:09
Message-ID: 20041028172009.GA12318@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 27, 2004 at 16:26:13 -0600,
Guy Fraser <guy(at)incentre(dot)net> wrote:
>
> When calculating any usage based on time, it is a good idea to
> store usage in days:hours:minutes:seconds because they are static
> and stable, if you discount the deceleration of the earth and
> corrections in leap seconds for atomic clocks [see
> http://tycho.usno.navy.mil/leapsec.html ].

The length of calendar days isn't constant. In many timezones, one day a year
is 23 hours long and another is 25 hours long.

Having month and year intervals is useful for events that repeat monthly or
yearly in spite of there not being a constant number of seconds between
events.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Froggy / Froggy Corp. 2004-10-28 17:31:47 Re: [pgsql-fr-generale] Problème de threadPostgresql
Previous Message Tom Lane 2004-10-28 17:18:16 Re: field incrementing in a PL/pgSQL trigger