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



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
Previous
Next Post »