ASPͳ¼Æʱ¼ä¶Î¼Ç¼ÎÊÌâ

¸Õѧasp,ÓÃasp+access×öÁËÒ»¸öС³ÌÐòÏÖÔÚÏëͳ¼ÆÊý¾Ý¿âÖÐ2009-10-30 13:51:05µ½2009-11-3 18:51:05ËùÓмǼÊý²»ÖªµÀ¸ÄÔõôд¡£

---

select * from ±í where ÈÕÆÚ between '2009-10-30 13:51:05' and '2009-11-3 18:51:05'

---

SQL code:
select * from ±í where ÈÕÆÚ between #2009-10-30 13:51:05# and #2009-11-3 18:51:05#

---

ÒýÓÃ

select * from ±í where ÈÕÆÚ between '2009-10-30 13:51:05' and '2009-11-3 18:51:05'

Õý½â

---

ÒýÓÃ

¸Õѧasp,ÓÃasp+access×öÁËÒ»¸öС³ÌÐòÏÖÔÚÏëͳ¼ÆÊý¾Ý¿âÖÐ2009-10-30 13:51:05µ½2009-11-318:51:05ËùÓмǼÊý²»ÖªµÀ¸ÄÔõôд¡£

Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040e14'

[Microsoft][ODBC Microsoft Access Çý¶¯³ÌÐò] SELECT ×Ó¾äÖаüº¬Ò»¸ö±£Áô×Ö¡¢Æ´Ð´´íÎó»ò¶ªÊ§µÄ²ÎÊý£¬»ò±êµã·ûºÅ²»ÕýÈ·¡£

/1/index.asp£¬ÐÐ 824

Êý¾Ý¿âÖÐÊý¾ÝÊÇÈÕÆÚ/ʱ¼äÐÎ

---

Response.Write"·ûºÏÌõ¼þµÄÓУº"
set rs = conn.execute("select  count(xingming) from leave where QJRIQI between '2009-10-30 13:51:05' and '2009-11-3 18:51:05'  ")
Response.Write(rs(0))
Response.Write"ÈË"

ÎÒÓÃÕâÑùµÄ¾ä×Ó½á¹û³öÏÖ
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040