Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2608

Support for JSON date format

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Component/s: None
    • Labels:
      None

      Description

      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');
      

       

       

        Attachments

          Activity

            People

            Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: