Issue with Date if milliseconds are more than 3

Gunner49 — Fri, 30 Nov 2018 12:38:52 GMT

Hi All,

I need output date in format "9999-12-31 23:59:59.999999". If i am using expression in tMap as

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSSSSS","9999-12-31 23:59:59.999999"), output date is coming as "10000-01-01 00:16:38.000999", it is getting incremented by 1.

If i am using same function for upto 3 microseconds i.e. TalendDate.parseDate("yyyy-MM-dd HH:mm:ss.SSS","9999-12-31 23:59:59.999"), it is giving expected result.

Can you please suggest what format should i use for getting microseconds upto 6 digits.

Re: Issue with Date if milliseconds are more than 3

Anonymous — Fri, 30 Nov 2018 13:48:41 GMT

it is probably due to a precision problem, Talend round your .999999 to 1

I suggest you to set precision = 6 to your date in your schema.

Pierre

topic Re: Issue with Date if milliseconds are more than 3 in Talend Studio

Issue with Date if milliseconds are more than 3

Re: Issue with Date if milliseconds are more than 3