外接查询，控件日期与数据库日期格式不符问题

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)