CSV to MS SQL - Date Parsing

[mora1]

Hi,

I am try to move the CSV to MSSQL using tmap and getting the following error. The Date in csv file is like 12/3/2020 12:03 which is dd-MM-yyyy HH:mm

Error:

Couldn't parse value for column 'date' in 'row4', value is '2020-12-03 12:03:11'. Details: java.lang.RuntimeException: Unparseable date: "2020-12-03 12:03:11"

I am new to Talend. Can you help me to resolve this issue. The attached image shows how I am mapping the CSV file.

Thanks,

Mora

[Anonymous · Accepted solution]

Hi

As the error shows, the date format is "2020-12-03 12:03:11", please check if there exist different date format in your CSV file. The date pattern for "2020-12-03 12:03:11" is "yyyy-MM-dd HH:mm:ss"

Regards

Shong

[mora1]

Thanks a lot shong.. Changing the Date format to yyyy-MM-dd HH:mm:ss resolved the issue.