Dandandan opened a new issue, #22266:
URL: https://github.com/apache/datafusion/issues/22266

   Split out from #22247.
   
   ### Mismatch
   
   `extract(second ...)` should preserve fractional seconds.
   
   ```sql
   SELECT extract(second from timestamp '2020-01-01 00:00:12.345678');
   ```
   
   PostgreSQL:
   
   ```text
   12.345678
   ```
   
   DataFusion:
   
   ```text
   12
   ```
   
   ### Expected behavior
   
   For PostgreSQL-compatible SQL semantics, DataFusion should either match 
PostgreSQL's result or raise the same class of domain/semantic error.
   


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


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to