Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> to_date function
I am not sure what I am doing wrong, but when I run this query:
SQL> select to_date(11051946, 'MM-DD-YYYY') from dual; TO_DATE(11051946,'MM
05-NOV-46 But, when I change the number 11051946 to 11451946, I get an error:
SQL> select to_date(11451946, 'MM-DD-YYYY') from dual;
TO_DATE(11451946,'MM
ORA-01861: literal does not match format string
Any ideas?
thanks for the help
SG
1 row selected. Received on Wed Nov 07 2001 - 11:35:19 CST