Issue with Date if milliseconds are more than 3

[Gunner49]

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.

[Anonymous · Accepted solution]

Hi

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