topic Re: Unparsable date/time in Talend Studio

Unparsable date/time

Jacco_De_Zwart — Fri, 14 Nov 2025 14:29:29 GMT

Hi all,

Yes an other Unparsable date/time question here. I know, there are a lot out there, but I could not find any suitable for my case.

I get date/time values. In a tExtractJSONFields I'm able to get most of them with format

"yyyy-MM-dd'T'HH:mm:ss.SSSSSS"

But. . . . . this fails when a date/time has (for example) the following value :

2025-11-12T17:29:36

No miliseconds, no dot what so ever.

How to handle vlaues like these ???

Thanks in advance.

Jacco

Re: Unparsable date/time

brunobertels — Fri, 14 Nov 2025 15:26:07 GMT

use Alt() fonction that allow to test different datetime timestamp format

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/alt.htm

hope it helps

Re: Unparsable date/time

mikaelsc — Fri, 14 Nov 2025 17:14:47 GMT

if all your values have at least "yyyy-MM-dd'T'HH:mm:ss", why not

left(datetimevalue,21) and continue with that?

otherwise, somethging combining left(datetimevalue,28) & repeat('0',28-len(datetimevalue) )

(max length supposed to be 28... )

Re: Unparsable date/time

Shicong_Hong — Wed, 19 Nov 2025 08:15:51 GMT

@Jacco_De_Zwart

I suggest reading this field as a string type, then checking the length of the data and parsing the string data into a Date value using the corresponding date pattern on other component such as tJavaRow after ttExtractJSONFields.

Regards

Shicong

Re: Unparsable date/time

Nagaraju_KCS — Wed, 19 Nov 2025 08:21:59 GMT

Try this

Alt(
Timestamp#([Timestamp], 'YYYY-MM-DDThh:mm:ss.SSSSSS'),
Timestamp#([Timestamp], 'YYYY-MM-DDThh:mm:ss')
) AS DateTime