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.
Thursday, March 27, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment