Convert excel General to Date time

[thomas_2583]

Hi,

I have a date time in excel formatted as 'General' which outputs as this: 24/04/2023 13:54:50.

I am trying to bring this date time into the data warehouse but getting an error on the TMap.

The Tmap has this as a string and I am using this to convert to a date time TalendDate.parseDate("dd/MM/yyyy HH:mm", row1.test_date_time)  but get the following error message, any idea how to resolve this please?

Exception in component tMap_1 (DIM_morts)

java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Mon Apr 24 13:54:50 BST 2023"

at routines.TalendDate.parseDate(TalendDate.java:971)

at routines.TalendDate.parseDate(TalendDate.java:915)

at signal.dim_snapshots_new_0_1.

DIM_morts

.tFileInputExcel_1Process(

DIM_morts

.java:1273)

at signal.dim_snapshots_new_0_1.

DIM_morts

.runJobInTOS(

DIM_morts

.java:1911)

at signal.dim_snapshots_new_0_1.

DIM_morts

.main(

DIM_morts

.java:1749)

Caused by: java.text.ParseException: Unparseable date: "Mon Apr 24 13:54:50 BST 2023"

at java.base/java.text.DateFormat.parse(DateFormat.java:399)

at routines.TalendDate.parseDate(TalendDate.java:957)

... 4 more

[statistics] disconnected

[jlolling]

The problem is you read the date as String and that cause the component to convert the date value into a String by using the Java default pattern (thats what you see).

Please not not read it as String, read it as Date typed column!