ÇóÒ»¶ÎSQL - .NET¼¼Êõ / ASP.NET

»ñÈ¡µ±Ì죬2ÌìÄÚ£¬3ÌìÄÚ¡£¡£¡£¡£µÄÊý¾Ý
Select PostDate from View_ResumeAPply 
Where 
PostDate Between getDate()-3 And getDate()

ÎÒÏÖÔÚдµÄÕâ¸öÊÇ»ñÈ¡3ÌìÄÚµÄÊý¾Ý£¬µ«ÊÇÎÒÐèÒªµÄÊÇ´Ó3ÌìÇ°00:00:00µ½½ñÌì23:59:59µÄÊý¾Ý¶ø²¢²»ÊÇ£¬3ÌìÇ°µÄ17:13~½ñÌìµÄ17:13(¼ÙÉ赱ǰʱ¼äÊÇ17:13)¡£

Ó¦µ±ÈçºÎдÕâ¶ÎSQL£¿

---

SQL code:


Select PostDate from View_ResumeAPply
Where
DATEDIFF(d,getdate(),PostDate)>-3

---

SQL code:

Select PostDate from View_ResumeAPply
Where
DATEDIFF(d,getdate(),PostDate)>=-3






3ÌìÄÚÓ¦¸ÃÓÐ=µÄ

---

¶î¡£¡£ÎÒ¸Õ²Åû˵Çå³þ¡£ÒòΪÊÇǰ̨ҳÃæÓÐÒ»¸öÏÂÀ­Áбí¸øÓû§Ñ¡Ôñ£º1ÌìÄÚ 2ÌìÄÚ 3ÌìÄÚ ÕâÑù£¬ËùÒÔDATEDIFF(d,getdate(),PostDate)>-3 ,ÕâÀï¾Í²»ÄÜ»ñÈ¡µ½PostDate

---

Select PostDate from View_ResumeAPply Where  
convert(varchar(10),PostDate ,120) between convert(varchar(10),getDate()-3,120) and convert(varchar(10),getDate(),120)

---

covert(10,postDate,120) between convert(10,getdate()-3,120) and covert(10,getdate(),120)
ÓÃÕâ¸öÌõ¼þÊÔÏÂ

---

ÒýÓÃ

¶î¡£¡£ÎÒ¸Õ²Åû˵Çå³þ¡£ÒòΪÊÇǰ̨ҳÃæÓÐÒ»¸öÏÂÀ­Áбí¸øÓû§Ñ¡Ôñ£º1ÌìÄÚ 2ÌìÄÚ 3ÌìÄÚ ÕâÑù£¬ËùÒÔDATEDIFF(d,getdate(),PostDate)>-3 ,ÕâÀï¾Í²»ÄÜ»ñÈ¡µ½PostDate