Changing values with another value

Hi Vishnu,

Find the query below
SELECT ID, MONTHNAME('2001-' + Month + '-01') AS mnth
FROM table

Hope this answers your question.

Hi yokzu,

if you want to pass only month number then you can do something like

DECLARE @Mth smallint

SET @Mth = 1

SELECT DateName(mm,DATEADD(mm,@Mth,-1)) as [MonthName]

if you want to apply it for your table then use it like

Create Table #Monthtbl

(

Id int,

MonthNo int

)

insert into #Monthtbl values(1,1)

insert into #Monthtbl values(2,2)

insert into #Monthtbl values(3,3)

insert into #Monthtbl values(4,4)

SELECT Id,DateName(mm,DATEADD(mm,MonthNo,-1)) as [MonthName] from #Monthtbl

Vulpes11y ago

Something like this should work:

SELECT ID, DATENAME(m, DATEADD(m, [Month] - 1, '2000-01-01') As [Month Name] From MyTable