mysql时间运算

DELETE FROM zhongqiu WHERE caretatime<=ADDDATE(NOW(),-14)

caretatime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

CONCAT(serviceDate,' ', serviceTime) >= '2015-09-21 10:26:54'

DATE_FORMAT(ADDDATE(NOW(),INTERVAL 24 HOUR),"%Y-%m-%d %h:%i:%s");

posted on 2016-07-24 20:57  xihong  阅读(284)  评论(0编辑  收藏  举报

导航