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 -> Year 2000 Insert Statement

Year 2000 Insert Statement

From: Craig Nelson <cnelson_at_127.0.0.1>
Date: 1998/03/18
Message-ID: <6eoou2$d1e$1@clarknet.clark.net>#1/1

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