Interval of DAYs is only an estimate?

Database

Interval of DAYs is only an estimate?

Adding an INTERVAL '1' DAY to a timestamp value always yielded a result timestamp that is 4 seconds more than the expected value.
Is there a more *precise* way to add a 1 day interval?

Thank you.
Regards, Nancy
1 REPLY

Re: Interval of DAYs is only an estimate?

Is that so?
I ran the below SQL 2 times.
select current_timestamp, current_timestamp + interval '1' DAY

Current TimeStamp(6) (Current TimeStamp(6)+ 1)
2007-12-18 02:33:09.540000+00:00 2007-12-19 02:33:09.540000+00:00

Current TimeStamp(6) (Current TimeStamp(6)+ 1)
2007-12-18 02:33:57.720000+00:00 2007-12-19 02:33:57.720000+00:00