sqlʱ¼ä¼ÆËãÎÊÌâ

ntime Êý¾Ý¿âÖÐʱ¼ä×ֶΠ ¸ñʽΪ 2009-02-03

etime=date()

select * from Orders where fgs='¹þ¶û±õ' and (ntime - 2009-11-11 > 3) order by id desc


ÎÒÏë¼ÆËã µ±Ç°Ê±¼ä ¼õÈ¥ Êý¾ÝÖÐʱ¼ä ´óÓÚ 3¸öÔµÄÏÔʾ

---

Microsoft OLE DB Provider for SQL Server ´íÎó '80040e14'

µÚ 1 ÐÐ: 'dateDiff' ¸½½üÓÐÓï·¨´íÎó¡£

/webadmin/Manage_szhzQuery.asp£¬ÐÐ 78

---

ÊÇACCESS?
ACCESSµÄ»°,¼Ó'
sql="select * from Orders where fgs='¹þ¶û±õ' and dateDiff('m',ntime,"&etime&")>3 order by id desc"

---

11select * from Orders where fgs='¹þ¶û±õ' and dateDiff(m,ntime,2009-11-11)>3 order by id desc ´íÎó '80020009'

---

ACCESS:
sql="select * from Orders where fgs='¹þ¶û±õ' and dateDiff('m',ntime,#"&etime&"#)>3 order by id desc"

---

sqlÊý¾Ý¿â²»ÊÇACCESS

---

11select * from Orders where fgs='¹þ¶û±õ' and datediff(m,ntime,2009-11-11)>3 order by id desc ´íÎó '80020009'

---

sql="select * from Orders where fgs='¹þ¶û±õ' and dateDiff(m,ntime,'"&etime&"')>3 order by id desc"

SQL°¡,ÍüÁ˵¥ÒýºÅ

---

select * from Orders where fgs='¹þ¶û±õ' and datediff(m,ntime,'2009-11-11')>3 order by id desc
Microsoft VBScript ÔËÐÐʱ´íÎó