You are viewing a plain text version of this content. The canonical link for it is here.

Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/12/06 08:38:35 UTC

[GitHub] [arrow-datafusion] waitingkuo commented on pull request #4385: `date_part` support fractions of second

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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org