Anurag Shekhar created HIVE-25470: ------------------------------------- Summary: 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
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)