Support for JSON date format

Detail name	Value
Changelog Number	3116
Type	Improvement
Status	Resolved
Fix Versions	Exasol 7.0.0
Resolution Date	2020-09-11

Javascript Date Compatibility

If you convert a Javascript Date to JSON the resulting string looks like this:

1975-08-19T23:15:30.000Z

Exasol offers new format tokens to convert these timestamps 

Element	Description
T	ISO8601/JSON style date time separator
Z	ISO8601/JSON style UTC timezone designator

Example

SELECT TO_TIMESTAMP('1975-08-19T23:15:30.000Z', 'YYYY-MM-DDTHH:MI:SS.FF3Z');