The request returns the number of the month and you need its name

Question

I do in sql-serve (transact-sql), on MONTHNAME swears, how can I implement it differently?

  (select MONTH(CONVERT (date, GETDATE())))

Sergey74rus

165 1 golden mark 1 silver mark 13 bronze marks

|

1 answer 1

Sergey74rus Sergey74rus 165 1 golden mark 1 silver mark 13 bronze marks · Accepted Answer · 2016-05-13T14:52:52

The topic is closed, maybe someone will need

 SELECT DATENAME(MONTH, @df1) AS [months]