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