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

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: '1 year' = '360 days' ????
Date: 2004-10-24 07:25:28
Message-ID: E14F89B2-258D-11D9-B9F1-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 24, 2004, at 4:13 PM, Pierre-Frédéric Caillaud wrote:

> How can we sort intervals meaningfully in these conditions ? Can we ?
> In fact the value of an interval depends on the application, and
> intervals with months are in another 'world' than intervals with only
> seconds... same thing for years.

Added to this, I've been wondering whether '1 day'::interval is also
problematic wrt daylight savings time or changing time zones. The whole
thing seems pretty hairy to me.

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marek Lewczuk 2004-10-24 08:57:57 sequence behavior - is this correct
Previous Message Neil Conway 2004-10-24 07:19:42 Re: PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4