You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by Ashish Sharma <as...@gmail.com> on 2021/05/04 13:19:00 UTC

Default time zone value for date_format() UDF

Hi all,

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().

Thanks
Ashish Sharma