ÔÚÏߵȴý---ASP.NET°´Ê±¼ä²éѯµÄÎÊÌâ

ÔÚÒ³ÃæÖа´Ê±¼ä¶Î²éѯ  ±ÈÈç 3Ìì 7Ìì 1¸öÔ 3¸öÔ ÕâÑù²éѯµÄSQLÓï¾ä 

---

ͬÇó              .

---

ÓÃSQLSever Agent´úÀí¿ÉÒÔʵÏÖô £¿

---

DATEDIFF(day, pubdate, getdate())

---

ÃèÊö²»Çå³þ
ͬʱ°´Õ⼸¸öÊÀ¼Í·¶Î§²éѯ£¿

---

ÒýÓÃ

DATEDIFF(day, pubdate, getdate())

ºÜÕýÈ·£¡µ«ÄãÏîÄ¿ÔõôÑùÐèÒª¾ßÌå½øÐзÖÎö£¬Áé»î½øÐÐÔËÓã¡

---

Äܲ»ÄظöÌù³ö¾ßÌåµÄSQLÓï¾äѽ 

---

C# code:

select dateadd(day,-7,getdate())
select dateadd(month,-1,getdate())

---

Õâ¸öÒѾ­²»´íÁË

ÒýÓÃ

Èç¹ûÄãÒª±È½Ï¾«È·µÄ£¬¿ÉÒԲο¼ÏÂÃæµÄÕâЩд·¨

SQL code--µ±Ìì(usrRegTime>=CONVERT(varchar(10),getDate(),120)+' 00:00:00'and usrRegTime<=CONVERT(varchar (10),getDate(),120)+' 23:59:59')--½üÈýÌìDateDiff(day,usrRegTime,getdate())<=3--±¾ÖÜDatepart(year,usrRegTime)=DatePart(year,Getdate())andDatePart(week,usrRegTime)=DatePart (week,GetDate())--±¾ÔÂDatepart(year,usrRegTime)=DatePart(year,Getdate())andDatePart(month,usrRegTime)=DatePart (month,GetDate())