Repository navigation
PostgreSQL compatibility: time - interval should wrap within the 24-hour time domain #22255
Description
Split out from #22247.
Mismatch
time - interval should wrap within the 24-hour time domain.
SELECT time '01:30' - interval '2 hours';PostgreSQL:
23:30:00
DataFusion:
-30 mins
Expected behavior
For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.
Activity
raushanprabhakar1 commentedon May 17, 2026
take
avneesh91 commentedon Jun 15, 2026
@raushanprabhakar1 / @Dandandan - Since it's been a few weeks, I'm going to take a shot at fixing this subtraction wrapping logic and opening a PR. Let me know if you're still working on it!
avneesh91 commentedon Jun 16, 2026
ok it seems this PR -> #22280 solves both the addition as well as the subtraction!
fix: `time ± interval` returns a wrapped `time` instead of an interval (
fix: `time ± interval` returns a wrapped `time` instead of an interval (