Skip to content

PostgreSQL compatibility: extract(milliseconds ...) should preserve fractional milliseconds #22256

Description

@Dandandan

Split out from #22247.

Mismatch

extract(milliseconds ...) should preserve fractional milliseconds.

SELECT extract(milliseconds from timestamp '2020-01-01 00:00:12.345678');

PostgreSQL:

12345.678

DataFusion:

12345

Expected behavior

For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.

Metadata

Metadata

Assignees

Labels

bugSomething isn't workinggood first issueGood for newcomers

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions