Skip to Content
0
Former Member
Mar 27, 2009 at 03:08 PM

how to use todate function in JDBC adapter

670 Views

Hi All,

How can we use the todate function to update a date field in Oracle database. I am getting a

java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

Exception, when I am mapping the date fields with to_date('03/28/2009 18/43/19','MM/DD/YYYY HH24/MI/SS').

Thanks,

Yomesh