ÇóÒ»ÌõSQLÓï¾ä

Óиö±íÀïÓжà¸öÈÕÆÚµÄÊý¾Ý£¬ÈÕÆÚÊý¾ÝµÄ×Ö¶ÎÊÇopday£¬±È·½¸Ã±ítestµÄÊý¾ÝÈçÏ£º

  data      opday
  a        2009-11-04
  b        2009-11-03
  c        2009-11-02

ÏÖÔÚµÄÒªÇóÊÇҪѡÔñµ±ÌìµÄÊý¾Ý³öÀ´£¬±È·½½ñÌìÊÇ4ºÅ£¬¾ÍÑ¡Ôñ4ºÅµÄÊý¾Ýa³öÀ´£¬Èô½ñÌìÊÇ3ºÅÔòÑ¡È¡Êý¾Ýb³öÀ´£¬ÇëÎÊÕâÌõSQLÓï¾ä¸ÃÔõôд°¡£¿¾ÍÊÇÕâ¾äºóÃæµÄÎʺÅÄÚÈݸÃÔõôд£¿SQLµÄº¯ÊýÀïÊÇ·ñÓÐÈ¡µ±ÌìÈÕÆڵĺ¯Êý°¡£¿

select data from test where opday=??
 

---

SQL code:
select * from test where datediff(day,opday,getdate())=0

---

SQL code:

select * from test where datediff(day,opday,getdate())=0

---

SQL code:
--or
select * from test where convert(varchar(10),opday,120)=convert(varchar(10),getdate(),120)

---

SQL code:

select * from test where day(opday)=day(getdate())

---

select data from test where opday=select convert(nvarchar,getdate(),23)

---

DATEDIFF