You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "shajini thayasingh (Jira)" <ji...@apache.org> on 2020/11/02 17:31:00 UTC
[jira] [Assigned] (IMPALA-10306) [DOC] Extend FROM_UNIXTIME() doc
with Timezone offset behaviour.
[ https://issues.apache.org/jira/browse/IMPALA-10306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
shajini thayasingh reassigned IMPALA-10306:
-------------------------------------------
Assignee: shajini thayasingh
> [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
> Assignee: shajini thayasingh
> Priority: Major
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org