Question

How to find particular month in table using sql server 2008 R2

Answer 1

Hi,

SELECT DATENAME(month, <fieldname>) AS "Month Name" FROM <tablename>

all you have to do is replace the values of <> tags with your own values

Example query.:

SELECT DATENAME(month, JoinDate) AS "Month Name" FROM EMPLOYEE

hope it help you.