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.
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 |