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: Bob Withers <Bob.Withers_at_mci.com>
Date: 1998/03/25
Message-ID: <MPG.f82beb2c27ce95d9896a8@news.internetmci.com>#1/1 







In article <6eoou2$d1e$1_at_clarknet.clark.net>, cnelson_at_127.0.0.1 says...


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

> 




Try using: 	to_date('2000-01-01','YYYY-MM-DD')



Bob
Received on Wed Mar 25 1998 - 00:00:00 CST












Original text of this message













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