get Date in specific format from sqlserver 2012

Question

I have a table named NewsMaster which has a column named NewsDate .

Date is stored as 2016-05-19 00:00:00.000 in this table.

Now i want to retrieve this date as something like October-2016 . that's it. looked so many blogs but nothing found.

DATENAME(month,GETDATE()) 'Month Name'

is this helpful? am i close? need modification.

FORMAT() or DATENAME(MONTH, col) + '-' + DATENAME(YEAR, col) — Alex K.
– Alex K., Commented May 26, 2016 at 11:07
SELECT DATENAME(MONTH, NewsDate) + '-' + DATENAME(YEAR, NewsDate) FROM NewsMaster — Alex K.
– Alex K., Commented May 26, 2016 at 11:18

Krishnraj Rana · Accepted Answer · 2016-05-26 11:19:56Z

2

Try this

Select DATENAME(month,GETDATE())+' - '+ convert(nvarchar,DATEPART(yyyy,GETDATE()))

Krishnraj Rana

6,6583 gold badges33 silver badges37 bronze badges

answered May 26, 2016 at 11:19

Neena

565 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Krishnraj Rana · Accepted Answer · 2016-05-26 11:11:17Z

1

You can use Format() function introduced in sql server 2012. Try this -

SELECT FORMAT(CAST('2016-05-19' AS DATE), 'MMM-yyyy')

Result

May-2016

You can use it in your query like this -

SELECT FORMAT(NewsDate, 'MMM-yyyy') AS NewsDate FROM yourTable

answered May 26, 2016 at 11:06

Krishnraj Rana

6,6583 gold badges33 silver badges37 bronze badges

my column name is NewsDate

'FORMAT' is not a recognized built-in function name. this is the error in your query

@DinavAhire: Are you sure you are using SQL Server 2012 ? check your instance\