Skip to content

SQL: incorrect interval reading with more than 3 fractional second digits #37423

@bpintea

Description

@bpintea

The interval parsing yields incorrect results when fractional second part is on more than 3 digits:

sql> select interval -'22 22:21:20.19182' day to second;
INTERVAL '22 22:21:20.19182' DAY TO SECOND
------------------------------------------
PT-550H-21M-39.182S

instead of expected result: PT-550H-21M-20.191S.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions