Why some dates have length of 23 and precision of 0?
Have few jobs that uses "yyyy-MM-dd HH:mm:ss.SSS" as date format and some are showing up length of 23 and precision of 0 and some are showing up with no length and precision. What is the reason for it?
Depends on your source.system, an example, MSSQL has Datetime and Datetime2 types. The Datetime2 stores more precission. So when Talend converts this input data into java date ... you also notice some precision thats just formatting the date to make it readable.
The reason ... if you need to know which events accord in time but are so close together you need to be more precise... adjusting cooling water levels in a nuclear factory ... and this might even not be precise enough!
