select 596 * interval '1' hour, 597 * interval '1' hour from (values 1);
EXPR$0 |EXPR$1 | -----------|----------------| PT2145600S |PT-2145767.296S |Notice that the second expression turns into a negative interval. Is that the expected behavior?
Cheers, -- Oscar Morante "Self-education is, I firmly believe, the only kind of education there is." -- Isaac Asimov.
signature.asc
Description: Digital signature