LabKey releases compatibility issues

home

Backwards compatibility issues in release 19.1 (March 1919)

Remote API date format change

The date format in JSON responses has been changed to include milliseconds: yyyy-MM-dd HH:mm:ss.SSS
In previous releases the following format was used: yyyy/MM/dd HH:mm:ss

Due to this, JavaScript and Python queries will use dates in those formats.
As an example, a select query will return:

  • 2011-07-19 00:00:00.000 (version >= 19.1)

instead of:

  • 2011/07/19 00:00:00 (version < 19.1)

Further infos in: Release Notes 19.1.x, chapter "Potential Backwards Compatibility Issues".

Fix: Adapt Python API scripts to the new date format. Since there is no milliseconds format directive, one solution would be to use the microseconds directive (%f)'%Y-%m-%d %H:%M:%S.%f', and remove the last 3 digits.

Discussion