How do I compare dates in SQL?
Page creation date :
Confirmed version of the operation
Verify Access Version
- 2003
Check the Windows version
- XP SP2 and later
Tips (a.m.)
When you compare dates in Access, Transact-SQL or Oracle
select * from テーブル where 更新日時 = '2009/01/01'
, but if you do the same in Access, you will get a "Data type mismatch in criteria" error at run time.
In Access, if you specify a date for an SQL minute, enclose the date with a .
select * from テーブル where 更新日時 = #2009/01/01#