大家帮忙看下
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 convert(varchar(12),in_time,23)= ' " & date1 & " ' And flag = 0 "