access ÖеÄdatetime×Ö¶ÎÔõÑùµÃµ½2010-01-20

string strDatefrom="2010-01-20";
string strDateTo="2010-01-21";

where FormatDateTime(updatetime,0)  between #" + strDatefrom + "# and #" + strDateTo + "#


ÎÒÏë°Ñupdatetime ÖеÄÈÕÆÚ 2010-1-20 14:11:39 ±äΪ 2010-01-20

---

SELECT format([datefiled],'yyyy-mm-dd')
from yourtable;

---

´ÓÂß¼­ÉÏÀ´Ëµ£¬ÄãµÄÕâ¸ö²»ÐèҪת¡£

---

Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'updatetime!=null and  format([updatetime],'yyyy-mm-dd')  between #2010-01-20# and #2010-01-21#' ÖС£

---

where updatetime!=null and  updatetime  >=#" + Convert.ToDateTime(strDatefrom) + "#  and  updatetime <=#" + Convert.ToDateTime(strDateTo) + "#

Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'updatetime!=null and  updatetime  >=#2010-1-18 0:00:00#  and  updatetime <=#2010-1-21 0:00:00#' ÖС£

ÓôÃÆ

---

C# code:

sql = "select id ,type,product_type,product_type2 from M_product where updatetime!=null and updatetime >=" + Convert.ToDateTime(strDatefrom) + " and updatetime <=" + Convert.ToDateTime(strDateTo) + " ";




Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'updatetime!=null and  updatetime  >=