Need Query to select birthday in dttime format
Posted on 2003-02-28
Im very much a newbie, so forgive me if this sounds dumb, but I have a problem with what seems like it should be a simple query.
I have MS SQL 7 running, and I have a table with a dttime value column named 'DOB' with birthdays in it. I want to write a script that querys the database daily to create a recordset of users in that database who have a birthday equal to the current date. To do this, I would need to wildcard a date query so it only looks for the month and date, but not year.
I know I can use a LIKE statement to find everyone with a birthday in a specific MONTH, but how can I combine the date with that also? Can anyone help me?