[HIVE-25470] Hive returns wrong value for select query involving time conversion

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Component/s: UDF
• Assignee: Anurag Shekhar
• Reporter: Anurag Shekhar
• Created: 20/Aug/21 06:59
• Updated: 20/Aug/21 07:08
• Resolved: 20/Aug/21 07:08

Description

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
-------------