Re: roundoff problem in time datatype

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: roundoff problem in time datatype
Date: 2005-09-26 07:39:38
Message-ID: Pine.LNX.4.44.0509260935310.28238-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Sun, 25 Sep 2005, Tom Lane wrote:

> Alternatively: why are we forbidding the value 24:00:00 anyway? Is
> there a reason not to allow the hours field to exceed 23?

One reason is because it's what the standard demand. Another is that it
isn't a proper time, just like feb 31 isn't a proper date.

--
/Dennis Björklund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michał Jęczalik 2005-09-26 07:59:53 "expected authentication request from server, but received..."
Previous Message Bruce Momjian 2005-09-26 03:41:11 Re: [HACKERS] statement logging / extended query protocol

Browse pgsql-patches by date

  From Date Subject
Next Message Dave Cramer 2005-09-26 12:58:54 Re: roundoff problem in time datatype
Previous Message Bruce Momjian 2005-09-26 03:41:11 Re: [HACKERS] statement logging / extended query protocol