You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Andy Grove (Jira)" <ji...@apache.org> on 2020/09/16 00:02:00 UTC
[jira] [Resolved] (ARROW-9986) [Rust][DataFusion] TO_TIMESTAMP
function erroneously requires fractional seconds when no timezone is
present
[ https://issues.apache.org/jira/browse/ARROW-9986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andy Grove resolved ARROW-9986.
-------------------------------
Fix Version/s: 2.0.0
Resolution: Fixed
Issue resolved by pull request 8179
[https://github.com/apache/arrow/pull/8179]
> [Rust][DataFusion] TO_TIMESTAMP function erroneously requires fractional seconds when no timezone is present
> ------------------------------------------------------------------------------------------------------------
>
> Key: ARROW-9986
> URL: https://issues.apache.org/jira/browse/ARROW-9986
> Project: Apache Arrow
> Issue Type: Sub-task
> Reporter: Andrew Lamb
> Assignee: Andrew Lamb
> Priority: Minor
> Labels: pull-request-available
> Fix For: 2.0.0
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> Reported by [~jhorstmann] here: https://github.com/apache/arrow/pull/8161#issuecomment-691468844
> >One (not directly related) issue I noticed while trying this out, is that the local patterns seem to require the millisecond part, while for utc timestamps with "Z" they are optional:
> Both of the following timestamps should be supported, but only the one with an explicit timestamp is:
> {code}
> > select to_timestamp('2020-09-12T10:30:00') from test limit 1;
> ArrowError(ExternalError(General("Error parsing \'2020-09-12T10:30:00\' as timestamp")))
> > select to_timestamp('2020-09-12T10:30:00Z') from test limit 1;
> +-------------------------------------------+
> | totimestamp(Utf8("2020-09-12T10:30:00Z")) |
> +-------------------------------------------+
> | 1599906600000000000 |
> +-------------------------------------------+
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)