[ https://issues.apache.org/jira/browse/HIVE-25470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Shekhar reassigned HIVE-25470: ------------------------------------- > Hive returns wrong value for select query involving time conversion > ------------------------------------------------------------------- > > Key: HIVE-25470 > URL: https://issues.apache.org/jira/browse/HIVE-25470 > Project: Hive > Issue Type: Bug > Components: UDF > Reporter: Anurag Shekhar > Assignee: Anurag Shekhar > Priority: Minor > > Select > to_date(CAST(FROM_UNIXTIME(UNIX_TIMESTAMP(date_add('0021-02-01',cast(20 as > int)),'yyyy-MM-dd')) as timestamp)); > ------------- > _c0 > ------------- > 0021-02-23 > ------------- -- This message was sent by Atlassian Jira (v8.3.4#803005)