Home Forums SQL Server 2005 T-SQL (SS2K5) datetime to month - year RE: datetime to month - year

  • March 19, 2009 at 10:22 am

    #962879

    Will this work for you?

    select left(datename(mm, getdate()), 3) + '-' + cast(datename(yyyy, getdate()) as char(4))