• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Midnight 12:00am or 12:00pm

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Midnight 12:00am or 12:00pm

    Which is it?

    I think the former
    38
    am
    92.11%
    35
    pm
    7.89%
    3
    Down with racism. Long live miscegenation!

    #2
    So does 11pm come before or after midnight.
    Feist - 1234. One camera, one take, no editing. Superb. How they did it
    Feist - I Feel It All
    Feist - The Bad In Each Other (Later With Jools Holland)

    Comment


      #3
      Originally posted by NotAllThere View Post
      Which is it?

      I think the former
      I've always thought it was 12am

      SQL Server treats it as AM:


      select convert(varchar, cast('20080101' as datetime), 109)
      Jan 1 2008 12:00:00:000AM
      Coffee's for closers

      Comment


        #4
        Originally posted by PAH View Post
        So does 11pm come before or after midnight.
        after

        12 midnight = 00:00 hours and is the start of a new day
        Coffee's for closers

        Comment


          #5
          Originally posted by Spacecadet View Post
          I've always thought it was 12am

          SQL Server treats it as AM:


          select convert(varchar, cast('20080101' as datetime), 109)
          Jan 1 2008 12:00:00:000AM


          Then it's wrong. Midnight cannot be after midnight. It's 12pm, everything else is illogical. Spock will back me up...
          Feist - 1234. One camera, one take, no editing. Superb. How they did it
          Feist - I Feel It All
          Feist - The Bad In Each Other (Later With Jools Holland)

          Comment


            #6
            Neither. It's 12 noon or 12 midnight. If you must choose it's AM since it's 00.00 not 24:00 and it's the start of a new day.

            Comment


              #7
              I just use 00:00

              AM/PM is therefore not relevant.

              Comment


                #8
                Originally posted by ASB View Post
                Neither. It's 12 noon or 12 midnight. If you must choose it's AM since it's 00.00 not 24:00 and it's the start of a new day.
                WHS.

                Comment


                  #9
                  24:00:00
                  "Condoms should come with a free pack of earplugs."

                  Comment


                    #10
                    Since an instance in time lasts only an instance (or possibly 5.39121 x 10^-44 seconds), it's never (or only extremely briefly) exactly midnight. Therefore any time you're likely to measure is either before midnight (up to 23:59:59.999999999999999999 ) or after (from 00:00:00:000...001). So it should be 12:00am.

                    I think the convention is that is 12:00am - which is the consensus here. If that causes problems then use the 24 hour clock. According to wikipedia (yeah yeah) 24:00 is ok.
                    Down with racism. Long live miscegenation!

                    Comment

                    Working...
                    X