Originally posted by slimdave
Don't you mean "TRUNC(sysdate) + 1 + 13/24"?
Do you mean
TRUNC(sysdate) + 13/24 is wrong ?

IF I create MV today 11AM , can I use
TRUNC(SYSDATE) + 13/24 ( to refresh it on 1PM today and everyday afterwards )