I have database with field Name, Birthday, description, etc. I need help on SQL statement. How to show record whose birthday fall on this day on current month??? Thank You!
select * from tablename where (to_days(now())=to_days(Birthday))
might work
It generate error message: Undefined function "to_days"
I forgot to tell you that I'm using Access SQL, maybe the language is different.
Thank You!
Hi,
you should do yourself a favour and install mysql, its free and beats the ass of access and the jet driver, access and odbc is a very bad way to use and learn databases, seriously dude, download and install an rdms
