Post reply

Question about Time Format

  • September 12, 2002 at 11:41 am

    #79121

    My SQL server shows the date by default in the military format. That is 14:00:00 hours. Is there a SET command or anything through which I can tell SQL server to show the time with AM/PM by default?

    Karthik

  • September 13, 2002 at 5:12 am

    #436476

    For output when you select you can use the CONVERT function with format, see BOL for more. However in QA and EM it will output in military unless you select with a convert.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply