Sql Help Again

[ranjith23]

Hi,

 

SQL:

select COURSE_ENDING_DT from PS_COURSE_TBL.....

 

O/P:

"2011-09-18 11:37:36.543"....

 

need output to be in this format: 

: "September 2011"

 

We are using SQL server

 

Thanks in advance

 

 

[dotnetrockz]

SELECT right(convert(varchar, getdate(), 106), 8)

 

 

declare @tempdate datetime='2011-09-18 11:37:36.543'

SELECT right(convert(varchar,@tempdate, 106), 8)

[Swetha9g]

select CAST(DATENAME(MONTH,COURSE_ENDING_DT ) AS VARCHAR(12)) + ' ' + CAST(YEAR(COURSE_ENDING_DT ) AS VARCHAR(4)) from PS_COURSE_TBL

[Silver_mani]

select CAST(DATENAME(MONTH,COURSE_ENDING_DT ) AS VARCHAR(12)) + ' ' + CAST(YEAR(COURSE_ENDING_DT ) AS VARCHAR(4)) from PS_COURSE_TBL

ee funtion tho mottam Month name vastunda .. i thought it just returns Sep