[jira] [Created] (IMPALA-10306) [DOC] Extend FROM_UNIXTIME() doc with Timezone offset behaviour.

["Gabor Kaszab (Jira)" <ji...@apache.org>]

Gabor Kaszab created IMPALA-10306:
-------------------------------------

             Summary: [DOC] Extend FROM_UNIXTIME() doc with Timezone offset behaviour.
                 Key: IMPALA-10306
                 URL: https://issues.apache.org/jira/browse/IMPALA-10306
             Project: IMPALA
          Issue Type: Bug
          Components: Docs
            Reporter: Gabor Kaszab


FROM_UNIXTIME() accepts a format parameter that is a string that represents how this function should format its output timestamp. This format parameter can contain a timezone offset, however even if we provide a TZ offset in the format parameter it won't be included in the result.

The reason is that Impala stores Timestamp without timezone in UTC and has no information of the timezone offset.

I think it would be nice to clarify this in the docs so that the users won't expect to get specific timezone offsets from this function as a result.



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