Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Date Insert Problem
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