asp ÈÕÆÚ²éѯ - Web ¿ª·¢ / ASP

aspÈçºÎ²éÕÒÏÔʾһÖܵÄÄÚÈÝÁÐ±í£¬È磺½ñÌìÊÇÐÇÆÚ¶þ,ÔõôÑù´ÓÊý¾Ý¿âÀïÃæÕÒµ½£¬´Óµ½½ñÌìΪһÖܵÄÄÚÈÝ£¬Êý¾Ý¿âµÄ×Ö¶ÎdateΪÈÕÆÚ¸ñʽ,ÈçºÎ²éÕÒÄØ£¿»¹ÓÐÏÔʾһ¸öÔ£¬Ò»¸ö¼¾¶È,Ò»Äê!

---

·µ»ØÒ»ÖÜÄÚµÄÊý¾Ý
select * from table where datediff(w,date,getdate())=0
·µ»ØÒ»ÔÂÄÚµÄÊý¾Ý
select * from table where datediff(m,date,getdate())=0
·µ»ØÒ»¼¾ÄÚµÄÊý¾Ý
select * from table where datediff(q,date,getdate())=0
·µ»ØÒ»ÄêÄÚµÄÊý¾Ý
select * from table where datediff(y,date,getdate())=0

---

°ï¶¥£¬ÉÏÃæ¸ö¿ÉÒÔÁË

---

VBScript code:

'°ÑÈÕÆÚת»»·ÅÔÚaspÀïÍê³É£¬¿ÉÒÔÊ¡µãÊý¾Ý¿â×ÊÔ´¡£Ò»ÏÂÊÇһЩÈÕÆÚת»»µÄ´úÂë¡£
'Ò»ÖÜ
date_from = DateAdd("d", 2-Weekday(Date()), Date())
date_to = DateAdd("d", 6, date_from)


'Ò»¸öÔÂ
date_from = CDate(Year(Date()) & "-" & Month(Date()) & "-1")
date_to = DateAdd("d", -1, DateAdd("m", 1, date_from))

'Ò»Äê
date_from = CDate(Year(Date()) & "-1-1")
date_to = DateAdd("d", -1, DateAdd("yyyy", 1, date_from))

'Ò»¼¾¶È
date_from = CDate(Year(Date()) & "-" & (Int(Month(Date())/3+0.9)-1)*3+1 & "-1")
date_to = DateAdd("d", -1, DateAdd("m", 3, date_from))

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHigh