topic Re: TalendDate.parseDate in Talend Studio

TalendDate.parseDate

jimbo20814 — Sat, 16 Nov 2024 02:07:27 GMT

All, I have a headscratcher here, I've hardcoded a date to demo. How is TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSSSSS", "2020-06-17 21:14:28.9761776") returning the date 2020-06-17 23:57:09.000776

What the heck is happening here?

Re: TalendDate.parseDate

Anonymous — Thu, 18 Jun 2020 05:18:28 GMT

Hello,

Could you please let us know if this article helps?

https://community.talend.com/t5/Architecture-Best-Practices-and/How-to-fetch-data-that-uses-the-date-format-in-microseconds-quot/ta-p/137259

Best regards

Sabrina

Re: TalendDate.parseDate

jimbo20814 — Thu, 18 Jun 2020 14:31:07 GMT

No, I'm not looking to get the system/current time with milliseconds. I'm looking to convert a string to a datetime with milliseconds. Interestingly enough in the article, it mentions the Java API support only three digits, so I changed the hardcoded string to... TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSSSSS", "2020-06-17 21:14:28.976") and now it's returning 2020-06-17 21:14:28.000976 so now its' getting the hours/minutes/seconds correct but the milliseconds is .000976 not .976

Why is it not returning .976 for the milliseconds and how can it be resolved?

Re: TalendDate.parseDate

jimbo20814 — Thu, 18 Jun 2020 14:45:28 GMT

This has been resolved, sorry not familiar date formatting just changed to .SSS on milliseconds instead of .SSSSSS