
Question:
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.
Solution:1
SELECT * FROM {tablename} WHERE DAY({datecolumn})=DAY(getdate()) AND MONTH({datecolumn})=MONTH(getdate())
Solution:2
I would use DATEPART to pull out the values you're looking for.
Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
EmoticonEmoticon