Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4782

TO_TIME function cannot separate time from date time string

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.6.0, 1.7.0
    • 1.17.0
    • Server

    • CentOS 7

    Description

      TO_TIME('2016-03-03 00:00', ''yyyy-MM-dd HH:mm') returns "05:14:46.656" instead of the expected "00:00:00"

      Adding and additional split does work as expected: TO_TIME(SPLIT('2016-03-03 00:00', ' ')[1], 'HH:mm')

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-7139 Date_add() can produce incorrect results when adding to a timestamp

          • Major - Major loss of function.
          • Closed
          links to

          Web Link GitHub Pull Request #1784

          Activity

            People

              dgrinchenko Dmytriy Grinchenko
              mattk Matt Keranen
              Igor Guzenko Igor Guzenko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: