Ashish Sharma created HIVE-25093:
------------------------------------
Summary: date_format() UDF is returning values in UTC time zone
only
Key: HIVE-25093
URL: https://issues.apache.org/jira/browse/HIVE-25093
Project: Hive
Issue Type: Bug
Components: UDF
Affects Versions: 3.1.2
Reporter: Ashish Sharma
Assignee: Ashish Sharma
Query - select date_format(current_timestamp,"yyyy-MM-dd HH:mm:ss.SSS z")
Result - 2021-05-04 13:00:33.358 UTC
https://issues.apache.org/jira/browse/HIVE-12192
As part of above jira it was decided to have a common time zone for all
computation i.e. "UTC". Due to which data_format() function was hard coded to
"UTC".
https://issues.apache.org/jira/browse/HIVE-21039
But later it was decided that user session time zone value should be the
default not UTC.
date_format() was not fixed as part of HIVE-21039.
Dropping this mail to understand what should be the ideal time zone value of
date_format().
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
