Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Input date of 01-JAN-99 Defaults to 01-JAN-2099
I am trying to run this insert statement with a start_date of Jan 1, 1999: Insert into monthlyoffers
(offer_title, offer_desc, start_date, end_date, username, pointofcontact,
id_mom_category, id_market,
inserted_date)
Values
('Test','This is a test', '01-JAN-99', '', 'irosa', '', 8, 1,
'26-JAN-01');
The statement runs fine, but when I run this query:
select to_char(start_date, 'DD-MON-YYYY')
from monthlyoffers
where start_date >='01-JAN-01';
Result is: 01-JAN-2099
Should this be happening? How do I force year 19xx? Received on Fri Jan 26 2001 - 20:30:39 CST