Oracle materialized views: 25/24 in REFRESH / NEXT parameter

Question

I'm trying to figure out the meaning of 25/24 in this REFRESH parameter of an Oracle materialized view found on a repository:

REFRESH FORCE ON DEMAND START WITH sysdate+0 NEXT trunc(SYSDATE) + 25/24

I'm trying to find the correct refresh scheduling of this Oracle materialized view: 1/24 means "every one hour' but I'm not sure about the meaning of 25/24 and I couldn't find the correct answer so far...

Can anyone give an help? Thanks in advance.

Marco

Answer 1

That's tomorrow, 1 hour after midnight:

SQL> select sysdate right_now,
  2         trunc(SYSDATE) + 25/24 what_is_that
  3  from dual;

RIGHT_NOW           WHAT_IS_THAT
------------------- -------------------
06.12.2022 12:20:53 07.12.2022 01:00:00

SQL>

trunc "removes" time component from sysdate (sets it to midnight) and then adds 25 hours to it.