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
01-01-99
01-01-9999
Date: 1996/02/01
Message-ID: <4eqqqd$rtm_at_cass.ma02.bull.com>#1/1
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 BrooksReceived on Thu Feb 01 1996 - 00:00:00 CET