how to get month name from month number in sql
how to get month name from month number in sql
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manoj BhoirPosted Jul 10, 2015, 5:34 AM
Manoj BhoirPosted Jul 10, 2015, 6:18 AM
Rohan GuptaPosted Jul 10, 2015, 6:16 AM
Upendra Pratap ShahiPosted Jul 10, 2015, 5:21 AM
Hello Rohan Gupta,
select datename(month, '2015-07-13') as MonthName
select datename(month, '2015-08-13') as MonthName
Sanjeeb LenkaPosted Jul 10, 2015, 5:06 AM
select datename(month, 'pass your date here') as MonthName
Rajeev PunhaniPosted Jul 10, 2015, 4:56 AM