[jira] [Created] (ARROW-9986) [Rust][DataFusion] TO_TIMESTAMP function erroneously requires fractional seconds when no timezone is present

["Andrew Lamb (Jira)" <ji...@apache.org>]

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)