CODEWITHSUNDEEP
vb.net
amol kadam
amol kadam

Reputation: 119

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

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.

Upvotes: 0

Views: 2258

Answers (2)

barrylloyd
barrylloyd

Reputation: 1589

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

Upvotes: 1

Jim B
Jim B

Reputation: 8574

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

Upvotes: 0

Related Questions