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

  • March 19, 2009 at 10:20 am

    #962875

    try..

    SELECT DATENAME(mm,'2009-01-23 1:12:52.253') + '-' + datename(yy,'2009-01-23 1:12:52.253')