An error is returned when the access database queries data by date !, Access date

An error is returned when the access database queries data by date !, Access date

<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>

There is no error in executing this SQL statement in SqlServer08, but an error is reported when it is executed in the access database!

Baidu once said

<Span style = "font-size: 18px;"> change '2017-1-20 0:00:00 'to #2015-1-20 0:00:00 # </span>

</pre><p></p><pre>

<span style="font-size:18px;"><span style="background-color: rgb(240, 240, 240);">select * from sv_JFVoucher  </span></span>

<span style="font-size:18px;">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;"> the operation was successful. I just got in touch with access, indicating that I was puzzled. </span>