Do null value in a date type format.

Anonymous — Sat, 16 Nov 2024 12:26:15 GMT

Hi All,
I have one source which is in date format, and some of the value inside the column is null. I try to map into a target with the same datatype, however it prompt me out an error while I try to
"Exception in component tMSSqlOutput_1 java.sql.SQLException: Only dates in the AD era are accepted.at net.sourceforge.jtds.jdbc.DateTime.<init>(DateTime.java:111)"
It will be ok if I try to put this query inside the filter:
row1.column_name == null?
TalendDate.parseDate("yyyy-MM-dd","1900-01-01"):row1.column_name.compareTo(TalendDate.parseDate
("yyyy-MM-dd","1900-01-01"))>0?row1.column_name:TalendDate.parseDate("yyyy-MM-dd","1900-01-01")
is the date format cannot be null when i try to use the etl?
Regards,
Fuzaimi

topic Do null value in a date type format. in Talend Studio

Do null value in a date type format.