mysql µÄdatetime ºÍdateÄܲ»ÄÜÖ±½Ó±È½Ï´óС

ÈçÌâ
ÎÒдµÄÒ»¸ösqlÓï¾äÉÏÓÐÒ»¸ö datetimeÀàÐÍ ÎÒÒªÓõ½ºÍdateÀàÐ͵ıȽÏ
Äܲ»ÄÜÖ±½Óд  datetime <=date£¿

---

²»ÄÜ£¬ÕâÊÇÁ½¸öÀàÐÍ£¬ÓÃCASTת»»
OR DATE_FORMAT(datetime,'%Y-%m')

---

²âÊÔÁËһϣ¬
SELECT '2009-6-1 12:00:00' <'2009-6-3'
½á¹ûΪ1£¬
ÊÇ¿ÉÒÔÖ±½ÓдµÄ£¬²»¹ý×îºÃת»»³ÉÀàÐÍÒ»ÖÂ

---

¿ÉÒÔÖ±½Ó±È,MYSQL»á½øÐÐ×Ô¶¯µÄת»»¡£ÉõÖÁ¿ÉÒÔºÍÊý×ÖÐÍ£¬Îı¾ÐͽøÐбȽϡ£

SQL code:
mysql> select curdate(),now(),curdate()<now();
+------------+---------------------+-----------------+
| curdate() | now() | curdate()<now() |
+------------+---------------------+-----------------+
| 2009-12-08 | 2009-12-08 16:24:38 | 1 |
+------------+---------------------+-----------------+
1 row in set (0.00 sec)

mysql>

---

ÒýÓÃ

²»ÄÜ£¬ÕâÊÇÁ½¸öÀàÐÍ£¬ÓÃCASTת»»
OR DATE_FORMAT(datetime,'%Y-%m')

select a.logid,a.staffid,a.title,a.edittime,b.staffname,b.orgid,c.orgcode from fitdoa.tb_oa_log a left join fitdoa.tb_oa_staff b ON a.staffid=b.staffid left join fitdoa.tb_oa_organization c ON b.orgid=c.orgid where c.parentid='D001' and select DATE_FORMAT(a.edittime,'Y% m% d%')>=SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY) and select DATE_FORMAT(a.edittime,'Y% m% d%'