没必要吧,直接比就可以了,sqlserver自己会转换的 比如"select * from table where datefiled='"+dtp.value+"'"
?? 好久没有用sql server了
用sql的函数. select * from table where YEAR(datefiled)='"+dtp.value.date.year+"' and MONTH(datefiled)='"+dtp.value.date.month+"' and DAY(datefiled)='"+dtp.value.date.day+"'
而数据库中DateTime日期形式是这样的:****-**-**-----------设为Date2这样比较看可以不:
Date Date3=Date1.year & "-" & Date1.Month & "-" & Date1.Day
Date Date4=Date2.year & "-" & Date2.Month & "-" & Date2.Day比较Date3和Date4就可以了!
比如"select * from table where datefiled='"+dtp.value+"'"
好久没有用sql server了
select * from table where YEAR(datefiled)='"+dtp.value.date.year+"' and MONTH(datefiled)='"+dtp.value.date.month+"' and DAY(datefiled)='"+dtp.value.date.day+"'