关于VB.NET的MSSQL语句出错问题
adapter = New SqlDataAdapter("select * from products where recordtime between # " & DateTime.Today & " 00:00:00 # and # " & DateTime.Today & " 23:59:59 # ", conn)
我MSSQL的recordtime字段数据类型为datetime
出错提示如下:第 1 行: '2013' 附近有语法错误。 MS?SQL VB.NET SqlDataAdapter adapter datetime
[解决办法]
where convert(varchar(100), recordtime, 120) between '" & DateTime.Today.ToString("yyyy-MM-dd 00:00:00") & "' and '" & DateTime.Today.ToString("yyyy-MM-dd 23:59:59") & "'