22,209
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
feixianxxx 2011-03-02
- 打赏
- 举报
[Quote=引用 2 楼 wwwwgou 的回复:]
SQL code
select * from tb where DATEDIFF(day, date_field, GETDATE()) = 0
[/Quote]
...
SQL code
select * from tb where DATEDIFF(day, date_field, GETDATE()) = 0
[/Quote]
...
Shawn 2011-03-02
- 打赏
- 举报
select * from tb where DATEDIFF(day, date_field, GETDATE()) = 0
快溜 2011-03-02
- 打赏
- 举报
select * from tb where date=convert(varchar(10),getdate(),120)
