SQL Server : month name from date column

Question

How to get the month name from a column?

I have a column txndate

Select Month(g.Txndate) as Month

This returns 1,2,3,4,.....12. How can I get Jan, Feb, Mar, etc?

This might help https://stackoverflow.com/questions/185520/convert-month-number-to-month-name-function-in-sql — apomene, Mar 12 '19 at 16:01

DxTx · Answer 1 · 2019-03-12T16:55:35.853

4

Try this...

SELECT CONVERT(CHAR(3), DATENAME(MONTH, GETDATE()))

Or this one (Thanks, Gordon Linoff)

SELECT LEFT(DATENAME(MONTH, GETDATE()), 3)

Customized for your table...

SELECT CONVERT(CHAR(3), DATENAME(MONTH, g.Txndate)) AS Month
SELECT LEFT(DATENAME(MONTH, g.Txndate), 3) AS Month

Result

+-------+
| Month |
+-------+
| Mar   |
+-------+

edited Mar 12 '19 at 16:55

answered Mar 12 '19 at 16:15

DxTx

2

I would use `LEFT()` instead of `CONVERT()`. – Gordon Linoff Mar 12 '19 at 16:42

score 2 · Accepted Answer · answered Mar 12 '19 at 16:01

2

Try below query

SELECT DATENAME (MONTH, DATEADD(MONTH, MONTH(Txndate) - 1, '1900-01-01')) MonthName

Or SELECT FORMAT(g.Txndate, 'MMMM') AS Result

answered Mar 12 '19 at 16:01

Amit

2 Answers2