Nikhil Gupta created HIVE-25268: ----------------------------------- Summary: date_format udf doesn't work for dates prior to 1900 if the timezone is different from UTC Key: HIVE-25268 URL: https://issues.apache.org/jira/browse/HIVE-25268 Project: Hive Issue Type: Bug Components: UDF Affects Versions: 3.1.2, 3.1.1, 3.1.0, 4.0.0 Reporter: Nikhil Gupta Fix For: 4.0.0
*HDI 3.6 (Hive 1.2.1)*: {code:java} select date_format('1400-01-14 01:00:00', 'yyyy-MM-dd HH:mm:ss Z'); ----------------------------+ | _c0 | ----------------------------+ | 1400-01-14 01:00:00 +0700 | ----------------------------+ {code} *HDI 4.0(Hive 3.1):* {code:java} select date_format('1400-01-14 01:00:00', 'yyyy-MM-dd HH:mm:ss Z'); +----------------------------+ | _c0 | +----------------------------+ | 1400-01-06 01:17:56 +0700 | +----------------------------+{code} VM timezone is set to 'Asia/Bangkok' -- This message was sent by Atlassian Jira (v8.3.4#803005)