22,300
社区成员




select * from tb where datediff(day,starttime,getdate())>=0
"select * from xx where datediff(d,input_time,'"+rs+"')";
"select * from xx where input_time = '"+rs+"'"
select * from tb where col between '2010-01-25' and dateadd(dd,1,'2010-01-25')
select *
from tb
where datediff(day,col,控件日期)=0
select getdate()
/*
------------------------------------------------------
2010-09-18 20:49:10.983
(所影响的行数为 1 行)
*/
select convert(varchar(10),getdate(),120)
/*
----------
2010-09-18
*/
select convert(varchar(10),'2010-01-25 09:23:04 ',120)