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

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/26011
• Assignee: Andrew Lamb
• Reporter: Andrew Lamb
• Created: 13/Sep/20 11:19
• Updated: 11/Jan/23 08:10
• Resolved: 16/Sep/20 00:01

Description

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:

> 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                       |
+-------------------------------------------+

Issue Links

• links to: GitHub Pull Request #8179