On Tue, Oct 04, 2005 at 10:40:11AM -0400, Bruce Momjian wrote: > Kouber Saparev wrote: > > >> > > >>select timestamp '2005-09-23 23:59:59.9999999' > > >> > > >>I get the following result (note the value of the seconds): > > >> > > >>2005-09-23 23:59:60.00 > > > > > > It's the leap second. > > > > It is not a leap second. Leap seconds are always either on the 30th of > > June or on the 31th of December. > > > > Here there is a list of all the leap seconds so far: > > http://en.wikipedia.org/wiki/Leap_second > > > > And, in fact, the wrong result is the same for each date, regardless of > > the year, month or day. > > Right. We allow leap seconds for any date/time. Are you saying we > should only allow them for certain dates/times?
We should do that for timestamp or timestamptz, but there's no way we could check for a bare time or timetz ... Also it'd require a recompile whenever a new leap second is added; and that the Wikipedia hints that leap seconds may disappear in 2008 in favor of "leap hours", whatever that may be. -- Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4 "That sort of implies that there are Emacs keystrokes which aren't obscure. I've been using it daily for 2 years now and have yet to discover any key sequence which makes any sense." (Paul Thomas) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
