topic Re: CSV to MS SQL - Date Parsing in Talend Studio

CSV to MS SQL - Date Parsing

mora1 — Sat, 16 Nov 2024 00:28:09 GMT

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

Re: CSV to MS SQL - Date Parsing

Anonymous — Wed, 10 Mar 2021 08:35:09 GMT

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

Re: CSV to MS SQL - Date Parsing

mora1 — Wed, 10 Mar 2021 10:07:56 GMT

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