Thursday, March 27, 2008

Date Queries in MS Access

Writting query in MS Access for Date column differes from other SQL formats. For eg Writing the sql in ORACLE you will follow this patterrn

Select First_Name, DOB from emp where dob='01/jul/2008'

whereas in Access it has to be written like this
Select First_Name, DOB from emp where dob=#01/jul/2008#

Access understands the literals enclosed within # as date.

No comments: