date comparision in Access

Keep Open and Learning
Post Reply
jiataifeng
Posts: 178
Joined: 30 Apr 2009 06:31

date comparision in Access

Post by jiataifeng » 27 Feb 2019 03:22

Oracle or MSSQL: select * from myTable where myDt<'2009-04-17 22:00:00'
Access : select * from myTable where myDt< #2009-04-17 22:00:00#

Post Reply