#datename

------------------------------------------------------------------------------

Terrafriend

Naturfriend

Treefriend

Eartfriend

Dirfriend

Clafriend

dustfriend

Fielfriend

Cerulfriend

Meadofriend

Grasfriend

Leafriend/Leaffriend

Greefriend

Sunfriend

SQL Server – Convert Number to Month Name

The code below converts a number to a Month and displays it as a Name. It works in Multiples of 12 (ie 13 is January)

DECLARE @Month int SET @Month = 4 Select DateName( month , DateAdd( month , @Month , 0 ) - 1 )

The above code displays April: (more…)