Hi friends,
I am a beginer. I had one problem related with the filter statement.
The database I am using is the MS Access database. I am using a Tomcat server and jsp technology.I wish to get a recordset showing the persons having Birthday today. The related column in the datadase is having the date of Birth of the persons in dd-mmm-yyyy format. If I use ' WHERE "columnname"=Date()' it is showing null entries in the recordsed as the format of the date is not matching with that of the column entries in the database.
Which command I've to write in WHERE statement for getting the current date in dd-mmm format?

what does mmm means? i know mm is for months with leading zeros but mmm i haven't heard this yet. but anyway use DATE_FORMAT()
DATE_FORMAT('1982-09-03', '%m-%Y-%d')