Hi;

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.

The exception

tarting job VmsToOra_Hislcdof_REc at 14:39 22/04/2008.
[statistics] connecting to socket on port 3531
[statistics] connected
[trace] connecting to socket on port 4620
[trace] connected
Exception in component tMap_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "2.0020626E7"
    at routines.TalendDate.parseDate(TalendDate.java:89)