Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. "All times are in Eastern Time"

"All times are in Eastern Time"

Scheduled Pinned Locked Moved The Lounge
question
43 Posts 22 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Rowdy Raider

    Ah, blame the French - it is agreed then - this mess is their fault. Seriously though in newer .Net and SQL DateTimeOffset is a support primitive type, and 99% of the time that is what you ought to be storing not DateTime. So many issues go away completely whith that simple change.

    G Offline
    G Offline
    G Tek
    wrote on last edited by
    #34

    Agreed, and we've looked into it. But retro-fitting that is easier said than done.

    1 Reply Last reply
    0
    • J Jim Dolson

      Actually, it's not British. Its French. Universal Time Coordinated (dumb Frogs can't even get sentence structure correct). Jim aka dumb American ham radio operator who, along with 700,000 other dumb American ham radio operators, only uses UTC when logging radio contacts.

      P Offline
      P Offline
      p51dfltln
      wrote on last edited by
      #35

      and a every single pilot that ever got a weather briefing... although we tend to call it ZULU

      1 Reply Last reply
      0
      • M Mark_Wallace

        Thanks, Google. WTF is "Eastern Time"? Time since the birth of Mao? Something to do with Scheherazade? Mongolian sheep-dung-decay time?

        I wanna be a eunuchs developer! Pass me a bread knife!

        R Offline
        R Offline
        realJSOP
        wrote on last edited by
        #36

        You know - 12 o-crock, 1 o-crock - talk like an oriental - you'll get it. :)

        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
        -----
        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
        -----
        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

        1 Reply Last reply
        0
        • M Mark_Wallace

          Thanks, Google. WTF is "Eastern Time"? Time since the birth of Mao? Something to do with Scheherazade? Mongolian sheep-dung-decay time?

          I wanna be a eunuchs developer! Pass me a bread knife!

          P Offline
          P Offline
          Plamen Dragiyski
          wrote on last edited by
          #37

          What use of time zones anyway? I live nearly 42° N. According to the encyclopedias the earth is ~40000km around equator. That means ~29322km at this latitude, so on every ~1222km east/west the sunset/sunrise differs by one hour and on every ~20km by one minute. And the sunset/sunrise is the only thing that matters in measuring the time.

          1 Reply Last reply
          0
          • K kalberts

            Marc Clifton wrote:

            Well, what do you think they should use, UTC?

            Well, didn't China ("which we call Red China") fairly recently switch to use a single time zone for the entire country? It makes sense. It really doesn't matter what you call the time when you get out of bed. People in the west DO get out of bed five hours later than the people in the west, so why should they both insist of calling it six o'clock, create a lot of problems. As long as you live isolated, you might want to insist on your day starting at 06:00, but once you start cooperating with someone far away, I cannot see one single advantage of labeling the same point in time with different values. I wouldn't mind UTC beeing established as the "time zone" for the entire world. (My country, Norway, is a tiny north-south string of land. Nevertheless, we span two complete time zones: The people up north (-east) see the morning sun two hours before the people on the west coast. We live well with that, and have always done.)

            F Offline
            F Offline
            fglenn
            wrote on last edited by
            #38

            Member 7989122 wrote:

            I wouldn't mind UTC beeing established as the "time zone" for the entire world.

            Being from the US, I would object to finding it dark outside at noon.

            Fletcher Glenn

            1 Reply Last reply
            0
            • OriginalGriffO OriginalGriff

              "It's British for GMT"

              Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

              M Offline
              M Offline
              Mark Starr
              wrote on last edited by
              #39

              Except that [generally] GMT gets adjusted for Daylight Savings, UTC does not (at least in my experience - not to say I'm any kind of expert here).

              OriginalGriffO 1 Reply Last reply
              0
              • M Mark Starr

                Except that [generally] GMT gets adjusted for Daylight Savings, UTC does not (at least in my experience - not to say I'm any kind of expert here).

                OriginalGriffO Offline
                OriginalGriffO Offline
                OriginalGriff
                wrote on last edited by
                #40

                Nope, GMT stands for Greenwich Mean Time, and is not adjusted - the UK switches between GMT and BST (GMT + 1) for winter and summer respectively.

                Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                M 1 Reply Last reply
                0
                • OriginalGriffO OriginalGriff

                  "It's British for GMT"

                  Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                  K Offline
                  K Offline
                  KP Lee
                  wrote on last edited by
                  #41

                  OriginalGriff wrote:

                  "It's British for GMT"

                  You must mean "UTC", SQL doesn't have a GETGMTDATE function. :-O

                  1 Reply Last reply
                  0
                  • OriginalGriffO OriginalGriff

                    Nope, GMT stands for Greenwich Mean Time, and is not adjusted - the UK switches between GMT and BST (GMT + 1) for winter and summer respectively.

                    Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

                    M Offline
                    M Offline
                    Mark Starr
                    wrote on last edited by
                    #42

                    Interesting. I'll look into that on our servers. I've seen the GMT reference (yes I know what GMT is short for), but not a BST. but you are right - there is a separate check box for whether to adjust for DST. We have our severs set to UTC for consistency... Thanks for the info... Mark (just a cog in the wheel in Denver, CO)

                    1 Reply Last reply
                    0
                    • J Jim Dolson

                      Actually, it's not British. Its French. Universal Time Coordinated (dumb Frogs can't even get sentence structure correct). Jim aka dumb American ham radio operator who, along with 700,000 other dumb American ham radio operators, only uses UTC when logging radio contacts.

                      S Offline
                      S Offline
                      SteeleJ
                      wrote on last edited by
                      #43

                      Jim Dolson wrote:

                      Actually, it's not British. Its French.
                      Universal Time Coordinated (dumb Frogs can't even get sentence structure correct).

                      Jim, because it was the result of a compromise: http://en.wikipedia.org/wiki/Coordinated_Universal_Time#Etymology[^]

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups