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

Home -> Community -> Usenet -> c.d.o.server -> Date Insert Problem

Date Insert Problem

From: camou <camou_at_camou>
Date: Mon, 06 Feb 2006 17:06:00 -0500
Message-ID: <11ufi294vu2eh51@news.supernews.com>


I am string to insert dates in this format :2005-08-19

I tried to do : insert into foo (foodate) values('2005-08-19');

foo date is an Oracle date type field.

I get [ORA-01861: literal does not match format string]

I can only get a text filed with dates in this format. How can i insert this.

Thanks! Received on Mon Feb 06 2006 - 16:06:00 CST

Original text of this message

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