ÇóÒ»ÌõmssqlÓï¾ä..?? - MS-SQL Server / »ù´¡Àà

ÇóÒ»ÌõmssqlÓï¾ä..??
±í news  
×Ö¶Îdtime µÄÀàÐÍÊÇdatetime
ÎÒҪɾ³ýËùÓÐ µ±Ç°·þÎñÆ÷ʱ¼ä¼õÈ¥ dtime×ֶδóÓÚ5ÌìµÄ¼Ç¼( getdate()-dtime )>5 µÃÔõôд.Çë´Í½Ì?? 

---

SQL code:
datediff(dd,dtime,getdate())>5

---

SQL code:
select *
from news
where datediff(dd,dtime,getdate())>5

---

SQL code:
dtime<dateadd(dd,-5,getdate())


д·¨Òª¸Ä³ÉÕâÑù×îºÃ

---

ÒýÓÃ

SQL code
datediff(dd,dtime,getdate())>5

´ó¸çÄܲ»ÄÜ°ïÎÒдÍêÕûÒ»µã..ÎÒÒ²ÊÇÓõ½datediff(dd,dtime,getdate())>5 µ«ÀÏÊÇÖ´Ðв»³É¹¦ лл

---

SQL code:
delete news where dtime<dateadd(dd,-5,getdate())


ÔÎ

---

SQL code:
delete news where datediff(dd,dtime,getdate())>5
Õâ¸öÓ¦¸ÃÄܳɹ¦°¡

---

²»³É¹¦±¨Ê²Ã´´íÎó?

---

лл.¸÷λ..

---

ѧϰÏ Óкô¦µÄ