Home Forums SQL Server 2005 T-SQL (SS2K5) Need to show HH and "AM" or "PM' RE: Need to show HH and "AM" or "PM'

  • November 3, 2009 at 12:43 pm

    #1074456

    here's one way to do it, i'm sure you'll get other examples to choose from:

    select CONVERT(varchar,datepart(hour,getdate()) % 12 ) + ' ' + CASE WHEN datepart(hour,getdate()) > =12 THEN 'PM' ELSE 'AM' END

    --preceeding zero for HH?

    select RIGHT('00' + CONVERT(varchar,datepart(hour,getdate()) % 12 ),2) + ' ' + CASE WHEN datepart(hour,getdate()) > =12 THEN 'PM' ELSE 'AM' END

    --results: 2 PM

    -- 02 PM

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!