Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Year 2000 Insert Statement

Re: Year 2000 Insert Statement

From: Andrew Barnett <nobody_at_spamandeggs.bp.com>
Date: 1998/03/18
Message-ID: <01bd52b8$93d4d160$8c0564a1@azmelw1358.mel.az.bp.com>#1/1

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>...

> 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.
>
Received on Wed Mar 18 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US