oracleは1日か数時間の差で時間を計算します
2642 ワード
sysdate+1
sysdate+1/24 1
sysdate+1/(24*60) 1
sysdate+1/(24*60*60) 1
sysdate-1
sysdate-1/24 1
sysdate-1/(24*60) 1
sysdate-1/(24*60*60) 1
---------------------
select from where between add_months(sysdate, -1) and sysdate; //
add_months(sysdate, -1)
add_months(sysdate, 1)
転載先:https://www.cnblogs.com/zrlhss/p/11510050.html