[jira] [Commented] (ARROW-637) [Format] Add time zone metadata to Timestamp type

["Julien Le Dem (JIRA)" <ji...@apache.org>]

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

Julien Le Dem commented on ARROW-637:
-------------------------------------

Sounds good to me with the following tweak:
 - timezone field present means data stored in that timezone (including UTC). Which means when displayed to the user it can be converted to the display timezone.
 - timezone field missing means the data is timezone-less similar to the SQL behavior. a Timestamp without timezone should be printed exactly the same (as if we had stored the string representing it) independently of the "client" timezone. It is stored as UTC but does not get converted to the user timezone.

> [Format] Add time zone metadata to Timestamp type
> -------------------------------------------------
>
>                 Key: ARROW-637
>                 URL: https://issues.apache.org/jira/browse/ARROW-637
>             Project: Apache Arrow
>          Issue Type: New Feature
>          Components: Format
>            Reporter: Wes McKinney
>
> As a metadata-only convenience, it would be useful to have an optional Olson time zone name in the {{Timestamp}} flatbuffers type: https://github.com/apache/arrow/blob/master/format/Message.fbs#L94
> Null or length-0 string would indicate that the data has no time zone (UTC)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)