Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-15622

Calcite. TIME and TIMESTAMP types are trim milliseconds.

    XMLWordPrintableJSON

Details

    Description

      for example ^

      query I
SELECT '1969-01-01 01:03:20.45432'::TIMESTAMP::VARCHAR
----
1969-01-01 01:03:20.45432

expected=1969-01-01 01:03:20.45432, actual=1969-01-01 01:03:20

      query I
SELECT '14:42:04.35'::TIME::VARCHAR
----
14:42:04.35

expected=14:42:04.35, actual=14:42:04

      /sql/types/timestamp/bc_timestamp.test[_ignore]
/sql/types/time/time_parsing.test

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-12248 Apache Calcite based query execution engine

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-19162 Sql. Trim all less than millisecond information from timestamp.

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. IGNITE-21567 Sql. Conversion from TIMESTAMP to TIMESTAMP_WITH_LOCAL_TIME_ZONE trims millis

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              xtern Pavel Pereslegin
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: