Change date to "month year"

[Ofina]

I want an SQL function that takes a datetime field and returns "month year".

Example:
04/30/2012

I want to return "April 2012" but still be sortable by date, not alphabetically.

 

[ralphtrent]

the function will only return to you the processed value of a single input. How you sort it will be in your select statement.

You can do this

Create you function to look like this

select 
case DatePart(Month, @DATE)
when 1 then 'January'
when 2 then 'February'
...
when 6 then 'June'
...
end + ' '  + convert(char(4),datepart(year, @DATE))

then when you call your select statement you will need to include the original date and a call to this function. then you will do the order by

so it would look e like this

select date, function_return
from table
order by date

 

[imex]

You can also try something like that:

select DateCol, (DATENAME(month, DateCol) + ' ' + CAST(Year(DateCol) as CHAR(4))) as MonthYear
from MyTable
order by DateCol

Hope it's useful.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]