https://www.cnblogs.com/space-place/p/5145556.html
加一天,加一小时,加一分钟,加一秒:
1
2
3
4
5
6
|
select sysdate +1 加一天 , sysdate+1/24 加1小时, sysdate+1/(24*60) as 加1分钟, sysdate+1/(24*60*60) as 加1秒钟 from dual |
https://www.cnblogs.com/space-place/p/5145556.html
加一天,加一小时,加一分钟,加一秒:
1
2
3
4
5
6
|
select sysdate +1 加一天 , sysdate+1/24 加1小时, sysdate+1/(24*60) as 加1分钟, sysdate+1/(24*60*60) as 加1秒钟 from dual |