MySQL字串轉時間戳查詢

尐鱼儿發表於2024-12-09

SELECT * FROM form1 WHERE fff!='1' AND aaa='1' AND MAKEDATE=CURDATE() AND (NOW() > DATE_ADD(STR_TO_DATE(CONCAT(UPDATEDATE,' ',UPDATETIME), '%Y-%m-%d %H:%i:%s'),INTERVAL 1 HOUR));

SELECT * FROM form1 WHERE fff!='1' AND aaa='1' AND MAKEDATE=CURDATE() AND (NOW() > DATE_ADD(STR_TO_DATE(CONCAT(MAKEDATE,' ',MAKETIME), '%Y-%m-%d %H:%i:%s'),INTERVAL 1 HOUR));

相關文章