Re: '1 year' = '360 days' ???? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: '1 year' = '360 days' ????
Date
Msg-id E14F89B2-258D-11D9-B9F1-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: '1 year' = '360 days' ????  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Responses Re: '1 year' = '360 days' ????  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
Next
From: Marek Lewczuk
Date:
Subject: sequence behavior - is this correct