一、SQL (Oracle)
select sysdate,sysdate-2/(60*24),t.* from test t;//当前时间两分钟前(减两分钟)
sysdate sysdate-2/(60*24)
2018/12/19 15:12:21 2018/12/19 15:10:21
select sysdate,sysdate-2 from test t;//减2天
sysdate sysdate-2
2018/12/19 15:22:56 2018/12/17 15:22:56
二、Java
Date now = new Date();
System.out.println("now:"+now);//now:Wed Dec 19 15:20:00 CST 2018
now.setMinutes(now.getMinutes()-2);
System.out.println("now:"+now);//now:Wed Dec 19 15:18:00 CST 2018