1.

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

Answer»

Hi,




SELECT DATENAME(MONTH, ) AS "Month Name" FROM


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.


Discussion

No Comment Found

Related InterviewSolutions