select sysdate,
(sysdate + 1) as add_a_day, --加1天
(sysdate + 1 / 24) as add_an_hour, --,加1小时
(sysdate + 1 / (24 * 60)) as add_a_minute, --加1分
(sysdate + 1 / (24 * 60 * 60)) as add_a_second --加1秒
from dual
ORACLE日期相加减
最新推荐文章于 2024-03-21 16:23:22 发布