[ https://issues.apache.org/jira/browse/HIVE-16008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis updated HIVE-16008: --------------------------------------- I cleared the fixVersion field since this ticket is still open. Please review this ticket and if the fix is already committed to a specific version please set the version accordingly and mark the ticket as RESOLVED. According to the [JIRA guidelines|https://cwiki.apache.org/confluence/display/Hive/HowToContribute] the fixVersion should be set only when the issue is resolved/closed. > TRUNC of a Day and Hour is not fetching the expected output in Hive > ------------------------------------------------------------------- > > Key: HIVE-16008 > URL: https://issues.apache.org/jira/browse/HIVE-16008 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 1.1.0 > Environment: Cloudera > Reporter: Vinoth Ragunathan > Priority: Minor > Labels: hive > Fix For: 1.2.3 > > Original Estimate: 96h > Remaining Estimate: 96h > > Trunc function for the Day and for an Hour is not fetching the expected > result in Hive. > However rest of the string units like 'MM', 'YYYY' works as expected > I tried the below in Hive > Query : > SELECT TRUNC('2016-12-11 01:02:04','DD') FROM sample_08; > SELECT TRUNC('2016-12-11 01:02:04','HH24') FROM sample_08; > Result: > NULL > Expectation: > Ideally it should be 2016-12-11 00:00:00 for day > 2016-12-11 01:00:00 for Hour > Thanks, > Vnoth R -- This message was sent by Atlassian Jira (v8.20.10#820010)