date1 = Format(CDate(DTPicker1.Value), "yyyy-mm-dd")
sql = "select * from information where datepart(dy,in_time)=" & date1 & " " & " And " & " & flag = 0 & "
这句应该怎么写呀
sql = "select * from information where datepart(dy,in_time)=" & date1 & " " & " And " & " & flag = 0 & "
in_time有时间,我现在只想把日期取出来和date1比较
sql = "select * from information where datepart(dy,in_time)=" & date1 & " " & " And " & " & flag = 0 & "
这句应该怎么写呀
sql = "select * from information where datepart(dy,in_time)=" & date1 & " " & " And " & " & flag = 0 & "
in_time有时间,我现在只想把日期取出来和date1比较
sql = "select * from information where convert(varchar(12),in_time,23)='" & date1 & "' And '" & flag = 0 & "'"
sql = "select * from information where convert(varchar(12),in_time,23)='" & date1 & "' And flag = 0 "这一段时.提示convert函数没有定义.应该怎么解决??