Hi, On Tue, Mar 15, 2022 at 12:54:58PM +0530, Prabhat Sahu wrote: > > 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?
Yes, you can't blindly assume that adding 24 hours will always be the same as adding a day. You can just justify_days if you want to force that behavior.
