How to check Day & month from date which is in Database table

Question

Hi

I have problem here... I want to check Day & month of date which is in database. There is date field is in database which is mm/dd/yyyy format If I use "select" query then whole Date is access but I want only these date's which having today's day & month Example: if today's date is 02/02/2010 then select only those date whose day is 02 & month is February.(Dont consider Year)

Please be free to ask if you have any problem for understand.

Answer 1

I would use DATEPART to pull out the values you're looking for.

Answer 2

SELECT   *
FROM     {tablename}
WHERE    DAY({datecolumn})=DAY(getdate()) 
AND      MONTH({datecolumn})=MONTH(getdate())