[ https://issues.apache.org/jira/browse/DRILL-4782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16862970#comment-16862970 ]
Pavel Semenov edited comment on DRILL-4782 at 6/13/19 11:23 AM: ---------------------------------------------------------------- Verified in 1.17.0-SNAPSHOT. Commit 2615d68de4e44b1f03f5c047018548c06a7396b4 TO_TIME function returns correct format {code:java} select TO_TIME('2016-03-03 00:00', 'yyyy-MM-dd HH:mm') from (values(1)); +----------+ | EXPR$0 | +----------+ | 00:00:00 | +----------+ {code} Fixed was (Author: pavel.semenov): Verified in 1.17.0-SNAPSHOT. Commit 2615d68de4e44b1f03f5c047018548c06a7396b4 TO_TIME function returns correct format {code} select TO_TIME('2016-03-03 00:00', 'yyyy-MM-dd HH:mm') from (values(1)); +----------+ | EXPR$0 | +----------+ | 00:00:00 | +----------+ {code} Fixed > TO_TIME function cannot separate time from date time string > ----------------------------------------------------------- > > Key: DRILL-4782 > URL: https://issues.apache.org/jira/browse/DRILL-4782 > Project: Apache Drill > Issue Type: Improvement > Components: Server > Affects Versions: 1.6.0, 1.7.0 > Environment: CentOS 7 > Reporter: Matt Keranen > Assignee: Dmytriy Grinchenko > Priority: Minor > Labels: ready-to-commit > Fix For: 1.17.0 > > > 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') -- This message was sent by Atlassian JIRA (v7.6.3#76005)