Horton

Re: time values past 24:00:00 (or rather 23:59:60)

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Berg <myon@debian.org>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Date: 2020-06-04T20:54:34Z
Lists: pgsql-bugs 
I wrote:
> Christoph Berg <myon@debian.org> writes:
>> This is not ok:

>> # select '23:59:60.999'::time;
>> time
>> --------------
>> 24:00:00.999

> Yeah.  Here's a draft patch for that (sans any regression tests as yet).

I pushed this fix, but only as far back as v10.  To apply it in the
9.x branches, we'd need to make the code support float timestamps,
and I didn't think it was worth the trouble.

			regards, tom lane

Commits

  1. Reject "23:59:60.nnn" in datetime input.