TOra and SQL*Plus
424488Jul 5 2004 — edited Jul 6 2004Hi,
I am trying to insert data in which some of it is converted from varchar2 datatype to a date type as follows:
insert into x select to_date(datoa, 'yyyy-mm-dd')
from y
In SQL*Plus 9.2.0.2 I get the error:
ORA-01861: Litteral does not match format string
In TOra 1.2.4 the insert is completed successfully.
Can anyone tell me why?
Thanks