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)

Reply via email to