我写的,不过有问题 Dim myendtime As DateTime myendtime = Now.Date Dim myconn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("conn")) Dim mycmd As String = "select pro_bh,pro_name,end_time from pro_bmyq where end_time like " & myendtime & " "
select pro_bh,pro_name,end_time from pro_bmyq where datediff(d,getdate(),end_time) =0
条件语句设成这样,其中'2004-12-3 15:00:00'可以替换成你传入的参数变量: where datediff(dd,'2004-12-3 15:00:00',endtime)=0
你看看这个SQL语句是不是你要的 "SELECT convert(char(10),JoinDate,120) as JoinDate FROM Articles
myendtime = Now.Date
Dim myconn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("conn"))
Dim mycmd As String = "select pro_bh,pro_name,end_time from pro_bmyq where end_time like " & myendtime & " "
where datediff(dd,'2004-12-3 15:00:00',endtime)=0
"SELECT convert(char(10),JoinDate,120) as JoinDate FROM Articles
convert(char(10),endtime ,121)=convert(char(10),getdate(),121)
FROM Articles
WHERE CONVERT(char(10),endtime ,121) = CONVERT(char(10),getdate(),121)