Thread: BUG #1025: current_time accepts 24:00:00

The following bug has been logged online:

Bug reference:      1025
Logged by:          Rex Recio

Email address:      rexrecio@yahoo.com

PostgreSQL version: 7.3.3

Operating system:   Red Hat Linux 7.3

Description:        current_time accepts 24:00:00

Details:

I have a table containing 2 columns with default values of current_date and
current_time.  When I don't fill in the values, the current_time default
sometimes fill-in a value of 24:00:00 instead of wrapping it to 00:00:00.
The other column with the current_date as default fills-in a value as if the
time is 23:59:59.

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> I have a table containing 2 columns with default values of current_date and
> current_time.  When I don't fill in the values, the current_time default
> sometimes fill-in a value of 24:00:00 instead of wrapping it to 00:00:00.

How is the time column actually declared?  If it's got limited precision
(eg, time(0)) then I would expect a current_time value just before
midnight to be rounded to 24:00:00, eg, 23:59:59.765321 -> 24:00:00.
That's not a bug IMHO.

You would probably be better off to replace this design with a single
timestamp column.

            regards, tom lane