Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Year 2000 Insert Statement
insert into table (column_name) values (to_date('01-JAN-2001', 'DD-MON-YYYY'))
-- Andrew - Wizzard barnetaj_at_bp.com Craig Nelson <cnelson_at_127.0.0.1> wrote in article <6eoou2$d1e$1_at_clarknet.clark.net>...Received on Wed Mar 18 1998 - 00:00:00 CST
> What is the format to insert a year2k date into an oracle database? It
> seems that the date format is DD-MTH-YR (2 digex year). When I insert
> '2000' in the year portion, it fails. I am running Oracle 7.3.
>