Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10306

[DOC] Extend FROM_UNIXTIME() doc with Timezone offset behaviour.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Docs
    • None
    • ghx-label-8

    Description

      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.

      Attachments

        Activity

          People

            shajini shajini thayasingh
            gaborkaszab Gabor Kaszab
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: