Re: Timestamp to time_t - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Timestamp to time_t
Date
Msg-id 4AAF9F4F020000250002AFF7@gw.wicourts.gov
Whole thread Raw
In response to Re: Timestamp to time_t  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
> (To me, the fact that the spec's idea of 2009-01-31 + 1 month
> corresponds to a value that current_date will never be equal to is
> a far greater show-stopper.)
You get to pick which way you want to normalize that to the calendar
-- 31 days past the start of the next month, or pulled back to the
last day of the next month which is not greater than 31.  The latter
is more common, but I've seen both practices in real world business
applications.
-Kevin


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: generalized index constraints
Next
From: Jeff Davis
Date:
Subject: Re: WIP: generalized index constraints