<span style= "FONT-SIZE:18PX;" >select * from Sv_jfvoucher where isdelete=0 and [date]>= ' 2015-1-20 0:00:00 ' and [Date] <= ' 2015-1-20 0:00:00 ' ORDER by ID desc</span>
This SQL statement is error-free in SqlServer08, but executes in an Access database!
Baidu a bit, said the
<span style= "FONT-SIZE:18PX;" ><span style= "color: #ff6666;" > ' 2015-1-20 0:00:00 ' </span> modified to </span><pre name= "code" class= "SQL" ><span style= "font-size : 18px;color: #ff0000; " > #2015 -1-20 0:00:00#</span>
<span style= "FONT-SIZE:18PX;" ></span>
<span style= "FONT-SIZE:18PX;" >select * from Sv_jfvoucher where isdelete=0 and [date]>= #2015 -1-20 0:00:00# and [Date] <= #2015 -1-20 0:00:00# order by ID desc</span>
<span style= "FONT-SIZE:18PX;" > Run really successful, I just contacted access, expressing confusion </span>
Access database query data by date type Error!