To avoid any confusion around parsing of dates/times, LUSID expects all timestamps to be in the standard format documented by the W3C here.  This format includes the date followed by a time with precision down to 6 decimal places in the seconds field.

Dates are primarily used in LUSID in the AsAt and EffectiveAt/EffectiveFrom fields (cut labels can also be used when specifying an EffectiveAt date).

Examples of valid formats are

  • YYYY-MM-DD, eg 2021-03-01
  • YYYY-MM-DDThh:mmZ, eg 2021-03-01T10:01Z
  • YYYY-MM-DDThh:mm:ssZ, eg 2021-03-01T10:01:30Z
  • YYYY-MM-DDThh:mm:ss.sZ, eg 2021-03-01T10:01:30.1234567Z

LUSID stores all dates/times in ISO UTC format.