You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "Andrew Lamb (Jira)" <ji...@apache.org> on 2020/09/13 11:20:00 UTC
[jira] [Created] (ARROW-9986) [Rust][DataFusion] TO_TIMESTAMP
function erroneously requires fractional seconds when no timezone is
present
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)