ÇóÒ»SQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÒ³ÃæÉϵõ½ÁËÒ»¸öÈÕÆÚsendTime,±ÈÈç½ñÌìÊÇ6ÔÂ1ºÅ£¬sendTime¸ÕºÃÒ²ÊÇ6ÔÂ1ºÅ£¬ÔòÄܲé³öÊý¾Ý¡£ÇóÓï¾ä
SQL code:

select * from aaa where sendTime=?????

---

ÒýÓÃ

select * from aaa where datediff(dd,sendTime,getdate()) = 0

-- Õý½â!

---

¶î£¬À´ÍíÁË¡£¡£¡£

---

SQL code:

--try

select * from aaa where right(convert(nvarchar(10),sendTime,120),5)='06-01'

---

SQL code:
select * from aaa where convert(nvarchar(10),sendTime,120)='2010-06-01'

---

,. .

---

¶àлʥÉÏ¡£
ÓÖ¿´µ½Ð¡FÁË··