You are not logged in.
How can one convert a Data Type 'Double' field containing a date (Example: 20020626E7) to date for Oracle.
I tested several solution with the standards functions of TALEND 2.2 but I always have an exception. The last test is as follows.
TalendDate.parseDate("yyyyMMdd",Mathematical.FFIX(row1.CDOFH_DATCDE,0)) Where row1.CDOFH_DATCDE is a field contening Data Type Double.
tarting job VmsToOra_Hislcdof_REc at 14:39 22/04/2008.
[statistics] connecting to socket on port 3531
[trace] connecting to socket on port 4620
Exception in component tMap_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2.0020626E7"