O'Reilly logo
  • Arun Maity thinks this is interesting:

NoteIn the timestamp, there are MM and mm characters. These are the month and minute definitions and care should be taken to ensure that they are used correctly in the date and time portions of a date field.Note also the ss and SSS fields. These are seconds and milliseconds. Again, care must be taken in their use within the time portion of a date.HH and hh are also case sensitive. HH is the hour portion of a 24-hour timestamp, whereas hh is 12-hour time.

From

Cover of Talend Open Studio Cookbook

Note

yyyy-MM-dd HH:mm:ss.SSS.