Home Forums SQL Server 2008 SQL Server 2008 - General Displaying time in 12 hour format RE: Displaying time in 12 hour format

  • December 13, 2010 at 5:29 am

    #1261630

    How about this ?

    SELECT CASE WHEN DATEPART( HH , GETDATE()) > 12 THEN CAST ( ( DATEPART( HH , GETDATE()) % 12 ) AS VARCHAR) + ' PM'

    ELSE CAST ( ( DATEPART( HH , GETDATE()) ) AS VARCHAR) + 'AM'

    END AS HourParam