Re: Adding seconds to a time

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Adding seconds to a time
Date: 2010-09-17 11:33:05
Message-ID: 20100917133305.5e3c2914@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, 16 Sep 2010 20:22:21 -0400, Lew <noone(at)lewscanon(dot)com> wrote:

Yeah of course, I didn't say it correctly so I reformulate:
IN CASE OF financial|contract's datation, be careful :-)

> Of course it's legally correct. One month after September 15 is October
> 15 by anyone's definition.
>
> The contract termination issue is not due to miscalculation of "plus one
> month" but to mistaken inclusion of the +1 month date within the contract
> period. The contract needs to be understood as "from date X through but
> not including X + '1 month'::interval'". The date X + '1
> month'::interval still is what it is, e.g., October 15 in your example.
>

--
Above all else -- sky.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-09-17 13:57:06 Re: List of User Defined Types?
Previous Message Siddharth Saha 2010-09-17 10:44:38 Re: Some Questions About SQL Functions