[resolved] Convert the BigDecimal Value into Date format
Hi,
I am using Talend Data Integration Tool (5.3.1r104014), i would like to integrate the data from Source database to destination data base with using tmap_1 component, the source and destination are MSSQL.
So From the source data base they define the date format like this 20101109(i.e. data type is Bigdecimal), but in the destination the date format is dd/mm/yyyy (i.e. data type is date).
I am unable to convert the Bigdecimal value into Date format and unable to give the null value.
Code:
TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",TalendDate.parseDate("yyyyMMdd",row1.newColumn.toString())))
When i am execute the above mentioned code in the Expression Builder, the result is "Exception in component tRowGenerator_1" appear.
And also i am unable to give the null date format like "12/31/1599" , Please find the attached screen shot.
Please help on the above two issues
Thanks in advance
Siva