如何将Oracle 当前日期加一天,一分钟

2025-04-29 12:16:21
推荐回答(1个)
回答1:

加1天:select sysdate + 1 from dual;
加1小时:select sysdate + 1/24 from dual;
加1分钟:select sysdate + 1/24/60 from dual;
加1秒:select sysdate + 1/24/60/60 from dual;