]> granicus.if.org Git - postgresql/commit
Allow times of 24:00:00 to match rounding behavior:
authorBruce Momjian <bruce@momjian.us>
Fri, 14 Oct 2005 11:47:57 +0000 (11:47 +0000)
committerBruce Momjian <bruce@momjian.us>
Fri, 14 Oct 2005 11:47:57 +0000 (11:47 +0000)
commita93bf4503ffc6d7cd6243a6324fb2ef206b10adf
treeb42cbc485e4250d2b1116ac9e52a5ac94f7d1d5f
parentdbc214f7e611ed32bd8208955486ba46d2dbc941
Allow times of 24:00:00 to match rounding behavior:

regression=# select '23:59:59.9'::time(0);
   time
----------
 24:00:00
(1 row)

This is bad because:

regression=# select '24:00:00'::time(0);
ERROR:  date/time field value out of range: "24:00:00"

The last example now works.
doc/src/sgml/datatype.sgml
src/backend/utils/adt/datetime.c
src/backend/utils/adt/nabstime.c
src/interfaces/ecpg/pgtypeslib/dt_common.c