SQL ʱ¼äµÄ¶Ô±È

ÓÐÕâÑùÒ»¸öÐèÇ󣬲éѯµ±ÌìµÄÊý¾Ý

±íÀï±ßÓиötime×ֶΣ¬ÕâÑù¸ÄÔõô²é°¡£¿

select * from table where time>µ±Ìì0µã and time <µ±Ìì24µã

ÍøÉÏÒ²²éÁËÏÂ

select * from table where time BETWEEN µ±Ìì0µã and µ±Ìì24µã

µ«ÊǾßÌåÔõô×ö¾Í²»ÖªµÀÁË

ÄÇλ°ïæ˵Ï£¬Ð»Ð»¡£

---

select * from table
where datediff(day,[time],getdate())

---

SQL code:
select * from table where datediff(dd , time , getdate()) = 0

select * from table where convert(varchar(10),time,120) = convert(varchar(10),getdate(),120)

---

SQL code:
select * from table
where datediff(day,[time],getdate())

---

ÒýÓÃ

select * from table
where datediff(day,[time],getdate())

select * from table
where datediff(day,[time],getdate()) = 0

---

SQL code:
select * from table where datediff(dd,time,getdate()) = 0

---

ÒýÓÃ

ÒýÓà 1 Â¥ feixianxxx µÄ»Ø¸´:
select * from table
where datediff(day,[time],getdate())


select * fr