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".
postgres=# select timestamp '01-MAR-22 20:59:59' + interval '00 05:00:01'
as interval;
interval
---------------------
2022-03-02 02:00:00
(1 row)
--
With Regards,
Prabhat Kumar Sahu
EnterpriseDB: http://www.enterprisedb.com
