Convert month No into its number ..(Ex. 1= Jan,2= Feb...)

[Amitkhare82]

Hi All,

How can we conevrt the Month no into its equivalent name..(Ex. 1= Jan,2= Feb...) & IF you can tell me how to contatenate the Month & Year in one column.
Here is the query which I am writing.

SELECT
Datepart(Year, UserData.tp_Cre ated),
MONTH(UserData. tp_Created),
FROM TABEL1

I want to have Month & year info into one column. data should be like Jan 2007, feb 2006 like this.
Pls suggest,

Thanks in Advance!!

[bwestover]

Try this:

Select Case Month(UserData.tp_Created)
When 1 Then 'Jan'
When 2 Then 'Feb'
When 3 Then 'Mar' (etc.....)
End + ' ' + convert(char(4),year(UserData.tp_Created))
From Table1

[odyoda]

Or, for less code:

LEFT(CONVERT( CHAR(19),UserDa ta.tp_Created,1 00),3)+ ' ' + RIGHT(YEAR(User Data.tp_Created ),4)

Just wrote this one myself today for our web dev.

[ck9663]

Try this:

Select Case Month(UserData.tp_Created)
When 1 Then 'Jan'
When 2 Then 'Feb'
When 3 Then 'Mar' (etc.....)
End + ' ' + convert(char(4),year(UserData.tp_Created))
From Table1

try this:

select substring(conve rt(char(8), UserData.tp_Cre ated,1),1,2)
from table1

[odyoda]

try this:

select substring(conve rt(char(8), UserData.tp_Cre ated,1),1,2)
from table1

All that does is return the "08". He is trying to then format that integer into the 3 character standardized month code followed by the 2-digit year.

[bwestover]

Yeah, ODYODA's got it right. And way cleaner than my way :)

Welcome to the Forums!!