How do I compare dates in SQL?

Page updated :

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#