waitingkuo commented on PR #4385:
URL:
https://github.com/apache/arrow-datafusion/pull/4385#issuecomment-1338967935
> @waitingkuo made in sync with postgres. I have found extract nanosecond
faces parser issue
>
> ```
> DataFusion CLI v14.0.0
> ❯ select EXTRACT(nanosecond FROM
to_timestamp('2020-09-08T12:00:12.12345678+00:00')); 🤔 Invalid statement: sql
parser error: Expected date/time field, found: nanosecond
> ```
>
> whereas nanosecond date_part works. I will create a ticket for this
@comphead sqlparser doesn't support nanosecond for now.
https://github.com/sqlparser-rs/sqlparser-rs/blob/813f4a2eff8f091b643058ac1a46a4fbffd96806/src/parser.rs#L1187-L1221
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
