-
Type:
Improvement
-
Status: Resolved
-
Priority:
Normal
-
Resolution: Fixed
-
Fix Version/s: Exasol 7.0.0, Exasol 7.0.alpha1
-
Component/s: None
-
Labels:None
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');