Date of 01-01-9999?

From: Jeff Boes <j.boes_at_zds.com>
Date: 1996/02/01
Message-ID: <4eqqqd$rtm_at_cass.ma02.bull.com>#1/1


We have a canned application which has somehow entered a value of '01-01-9999' in an Oracle 7.0 database (HP-UX). That is, we can do a

SELECT DATE_FIELD
FROM MY_TABLE; DATE_FIELD



01-01-99

or

SELECT TO_CHAR('DD-MM-YYYY', DATE_FIELD) FROM MY_TABLE; DATE_FIELD



01-01-9999

Oracle dates are normally limited to a top end of the year 4713 or so.

How did this date field acquire this value? We can't insert a row like this, or update an existing row.

--
~~~~~~~~~~~~~~~~|Words herein are mine, not my employer's.
Jeffery Boes    |"Einstein argued that there must be simplified explanations
Database Analyst| of nature, because God is not capricious or arbitrary.  No
j.boes_at_zds.com  | such faith comforts the software engineer."  --Fred Brooks
Received on Thu Feb 01 1996 - 00:00:00 CET

Original text of this message