Re: Formatting an Interval

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Formatting an Interval
Date: 2005-01-02 17:09:24
Message-ID: opsjzi9ylbcq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Note that there will be a loss of precision as an interval of 1 month, for
instance, does not mean any specific number of days, as :

1 february + 1 month = 1 march (1 month = 28 or 29 days)
1 december + 1 month = 1 january (1 month = 31 days)

Same for years etc.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Edmund Bacon 2005-01-03 23:02:30 Re: Formatting an Interval
Previous Message Kretschmer Andreas 2005-01-02 16:46:52 Re: Formatting an Interval