Month name in sql server 2008

Question

Possible Duplicate:
Convert Month Number to Month Name Function in SQL

Hi ....

how can i get month name by passing corresponding month number in sql server 2008 ..

thnks in advance....

dup : http://stackoverflow.com/questions/185520/convert-month-number-to-month-name-function-in-sql — Haim Evgi, Nov 29 '10 at 07:16

score 7 · Accepted Answer · edited Apr 15 '13 at 12:01

7

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

Ex:

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

This value would return the monthname corresponding to the date value in the field JoinDate from the table EMPLOYEE.

edited Apr 15 '13 at 12:01

Prahalad Gaggar

answered Nov 29 '10 at 08:12

Jaykay

1 Answers1