BUG #1025: current_time accepts 24:00:00

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1025: current_time accepts 24:00:00
Date: 2003-12-23 06:01:52
Message-ID: 20031223060152.61CD7CF891C@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1025
Logged by: Rex Recio

Email address: rexrecio(at)yahoo(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2003-12-23 08:09:01 Re: pg_connect() problem
Previous Message Michael Fuhr 2003-12-23 05:57:28 Re: pg_connect() problem