erratic-pattern opened a new issue, #10826:
URL: https://github.com/apache/datafusion/issues/10826
### Describe the bug
In postgreSQL, the following query is valid:
```sql
SELECT extract('epoch' FROM now());
```
However, in Datafusion I get the following error:
```
Invalid statement: sql parser error: Expected date/time field, found: 'epoch'
```
### To Reproduce
Attempt to run the above query in DataFusion CLI with the default PostgreSQL
dialect.
### Expected behavior
The query should parse successfully and produce results similar to the
following example from `psql`:
```
postgres=# select extract('epoch' from now());
extract
-------------------
1717761399.492846
(1 row)
```
### Additional context
_No response_
--
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]
