1.形成格式yyyy/mm/dd
select DATE_FORMAT(date('20161102'),'%Y/%m/%d')
结果:2016/11/02
2,当前时间加减
DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 15 MINUTE)
select DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 15 MINUTE) from dual;
1.形成格式yyyy/mm/dd
select DATE_FORMAT(date('20161102'),'%Y/%m/%d')
结果:2016/11/02
2,当前时间加减
DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 15 MINUTE)
select DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 15 MINUTE) from dual;