获取当前的年月日:
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %T') FROM DUAL;
SELECT DATE_FORMAT(NOW(),'%T') FROM DUAL;
查询项目 超过12点的数据
SELECT * FROM project WHERE DATE_FORMAT(paytime,'%T') >'12:00:00';
获取当前的年月日:
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %T') FROM DUAL;
SELECT DATE_FORMAT(NOW(),'%T') FROM DUAL;
SELECT * FROM project WHERE DATE_FORMAT(paytime,'%T') >'12:00:00';