Select Cast(Getdate() as Varchar(3))+'/'+Cast(Year(GetDate()) as Varchar(4)) [Modified Format]
Modified Format ------------- Oct/2013
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11),GETDATE(), 106), 8), ' ', '/') AS [Mon/YYYY]
Mon/YYYY -------- Nov/2013
SELECT CONVERT(VARCHAR(3), Datename(MONTH, Getdate())) + ' ' + CONVERT(VARCHAR, Year(Getdate()))
SELECT CAST(UPPER(DATENAME(MONTH, GETDATE())) AS VARCHAR(3)) + '/' + DATENAME(YEAR, GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)