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

TO_TIME function cannot separate time from date time string

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.0, 1.7.0
    • Fix Version/s: 1.17.0
    • Component/s: Server
    • Labels:
    • Environment:

      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: