Hi All, Kindly check the below scenario with INTERVAL datatype.
postgres=# select interval '01 20:59:59' + interval '00 05:00:01' as interval; interval ---------------- 1 day 26:00:00 (1 row)
Any operation with INTERVAL data, We are changing the interval values as "60 sec" as "next minute" "60 min" as "next hour" Similarly can't we consider "24 Hours" for "next day" ? Is there any specific purpose we are holding the hours as an increasing number beyond 24 hours also?
But when we are dealing with TIMESTAMP with INTERVAL values it's considered the "24 Hours" for "next day".