[jira] [Commented] (HIVE-25093) date_format() UDF is returning values in UTC time zone only

["Ashish Sharma (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-25093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17339475#comment-17339475 ] 

Ashish Sharma commented on HIVE-25093:
--------------------------------------

[~jcamachorodriguez] [~zvez] [~pvary] [~sankarh] what should be the ideal time zone value of date_format() ?



> 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
>            Priority: Trivial
>
> Query - select date_format(current_timestamp,"yyyy-MM-dd HH:mm:ss.SSS z")
> Result - 2021-05-04 13:00:33.358 UTC
> As part of HIVE-12192 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".
> But later in HIVE-21039 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.
> what should be the ideal time zone value of date_format().



--
This message was sent by Atlassian Jira
(v8.3.4#803005)