topic Doesn't TalendDate.parseDate() validate the date? in Talend Studio

Doesn't TalendDate.parseDate() validate the date?

COW_WW — Fri, 15 Nov 2024 21:56:04 GMT

Hello,

I'm using the TalendDate.parseDate() to convert the string to date.

When I'm entering the wrong date that doesn't exist TalendDate.parseDate("yyyy-MM-dd", "2023-02-48") I'm getting the result: 2023-03-20

I was pretty sure it should fail on the conversion.

Thanks

Anonymous — Tue, 04 Apr 2023 03:05:45 GMT

Hello @COW_WW BA ,

TalendDate.parseDate() will invoke the java.util.Calendar to parse the date and it won't validate the date.

As a workaround, please use SimpleDateFormat like:

new SimpleDateFormat("yyyy-MM-dd").parse("2023-03-02")

Thanks

Aiming

Anonymous — Tue, 04 Apr 2023 05:31:44 GMT

You can also use tSchemaCompliancdCheck to validate the date before converting the string to a Date.

Regards

Shong

COW_WW — Tue, 04 Apr 2023 14:01:10 GMT

Should this workaround validate the date? I just tried it and got the same result.

new SimpleDateFormat("yyyy-MM-dd").parse("2023-02-48")

The result is: 2023-03-20

jlolling_kloeckner — Wed, 05 Apr 2023 14:41:05 GMT

The typicall frameworks ignore such wrong dates and correct them automatically.

jlolling_kloeckner — Wed, 05 Apr 2023 14:42:26 GMT

This will not help!

jlolling_kloeckner — Wed, 05 Apr 2023 14:46:29 GMT

You need to switch of the lenient mode which cause the automatically correction.

To do so use: TalendDate.parseDate("yyyy-MM-dd", "2023-03-48", false)

You will get as result an exception like this: java.lang.IllegalArgumentException: DAY_OF_MONTH

jlolling_kloeckner — Wed, 05 Apr 2023 14:47:08 GMT

You need to switch off the lenient mode which cause the automatically correction.

To do so use: TalendDate.parseDate("yyyy-MM-dd", "2023-03-48", false)

You will get as result an exception like this: java.lang.IllegalArgumentException: DAY_OF_MONTH