accessÈÕÆڵIJéѯ

Êý¾Ý¿âÖб£´æµÄÊÇ
date1
2009-12-31 15:19:00
2009-12-28 15:19:00
2009-05-31 15:19:00
2009-11-31 15:19:00


ÊäÈëµÄ²éѯֵÊÇ2009-12-28

accessÔõÑù°ÑÕâÌõÊý¾Ý²é³öÀ´£¿

and val(date1) like '%" + dtpStartDate.Value.ToShortDateString() + "%'

²»ÐÐ

---

date1 ÊÇÈÕÆÚÀàÐÍ

---

select * from tt where format(date1,'yyyy-mm-dd')='2009-12-28'

---

DataRow[] drExist = dtGroupSub.Select("GS_LId='" + txtCurrentLayId.Text + "' and format(GS_StartDate,'yyyy-mm-dd')="+ dtpStartDate.Value.ToShortDateString()+"");

linq µÄ ¡£ºÃÏñ²»Ö§³Öformat

---

FORMATÊÇJETSQLº¯Êý£¬Ó¦¸ÃÖ§³Ö£¬Ä㽫ÄãµÄÉÏÊöSQLÓï¾äÏÔʾ³öÀ´¿´¿´£¬Ìáʾʲô

---

DataRow[] drExist = dtGroupSub.Select("GS_LId='" + txtCurrentLayId.Text + "' and convert(varchar(10),GS_StartDate,23)='"+ dtpStartDate.Value.ToShortDateString()+"'");

Ò²²»ÐÐ

---

ÊDzéѯdatatable¡£

---

ÒýÓÃ

select * from tt where format(date1,'yyyy-mm-dd')='2009-12-28'

Õâ¿ÉÒÔ£¬ÎÒ¸Õ¸Õ²âÊÔ¹ýÁË¡£¡£

---

format(date1,'yyyy-mm-dd')Êǽ«date1µÄÈÕÆÚ¸ñʽÉèÖÃΪyyyy-mm-dd?

---

and int(date1)=#2009-12-28#

---

datatableµÄ²éѯ¸úÖ±½Ó²éѯaccessºÍsqlµÄ±í²»Í¬¡£Óеã¹îÒì

int() cast varchar convert format Ö®ÀàµÄº¯Êý»òÃû³Æ¶¼ÎÞ·¨Ê¶±ð

---

ÊÇÊý¾ÝÒѾ­È¡µ½datatableÁË£¬ÔÙdatatableÀïÔÙ½øÐвéѯ¶Ô