[
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)
