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.