Andrew Lamb created ARROW-9986:
----------------------------------
Summary: [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
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)
