Sql Date in Format MMMYY

Question

How to get current date in sql to MMMYY i.e. OCT13

select Convert(varchar(10),getdate(),6) this will generate 11 Oct 13

I need to get OCT13 .

Any help appreciated.

Front end application cannot do this formating. I am exporting the data from sql to another sql server Thanks

Solution 1

SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '') AS [MMYY]

Solution 2

With the FORMAT Function its very easy to convert it to the right format: (for SQL Sever 2012)

SELECT FORMAT(GETDATE(), 'MMMyy')

Solution 3

SELECT UPPER(REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '')) AS [Mon-YY]