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. We're not all in the US: Annual rant about dates

We're not all in the US: Annual rant about dates

Scheduled Pinned Locked Moved The Lounge
databasecloudjsonquestion
67 Posts 40 Posters 5 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.
  • D Daniel Pfeffer

    Greg Utas wrote:

    the State Department's map featuring "Here be dragons"

    At least the rest of the Western world hasn't (yet) allowed the insane to take over the asylum. One of the reasons that I refuse to visit the US any more is that with all the "woke-ism" and other nonsense, no one (including the locals) knows what the proper standards of behavior are any more. I say nothing of the physical danger of going into many (most?) major cities.

    Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

    Greg UtasG Offline
    Greg UtasG Offline
    Greg Utas
    wrote on last edited by
    #12

    Visit Canada and you'll be disabused of the notion that the rest of the West hasn't allowed the insane to take over. Or New Zealand or Australia, for that matter. And that's not even mentioning the EU, which is almost beyond hope.

    Robust Services Core | Software Techniques for Lemmings | Articles
    The fox knows many things, but the hedgehog knows one big thing.

    <p><a href="https://github.com/GregUtas/robust-services-core/blob/master/README.md">Robust Services Core</a>
    <em>The fox knows many things, but the hedgehog knows one big thing.</em></p>

    D L R O 4 Replies Last reply
    0
    • Greg UtasG Greg Utas

      Visit Canada and you'll be disabused of the notion that the rest of the West hasn't allowed the insane to take over. Or New Zealand or Australia, for that matter. And that's not even mentioning the EU, which is almost beyond hope.

      Robust Services Core | Software Techniques for Lemmings | Articles
      The fox knows many things, but the hedgehog knows one big thing.

      D Offline
      D Offline
      Daniel Pfeffer
      wrote on last edited by
      #13

      Well, there are still plenty of places in Israel that I haven't visited yet... :)

      Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

      1 Reply Last reply
      0
      • C Chris Maunder

        Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

        cheers Chris Maunder

        J Offline
        J Offline
        jmaida
        wrote on last edited by
        #14

        For Chris Maunder: And now for something completely different (Monty Python). Are there any rules or restraints to posting code (C code) we have written? It's pretty short maybe 3 routines. I am the author of code but make references to the inspiration for it (all in the comments).

        "A little time, a little trouble, your better day" Badfinger

        C 1 Reply Last reply
        0
        • J jmaida

          For Chris Maunder: And now for something completely different (Monty Python). Are there any rules or restraints to posting code (C code) we have written? It's pretty short maybe 3 routines. I am the author of code but make references to the inspiration for it (all in the comments).

          "A little time, a little trouble, your better day" Badfinger

          C Offline
          C Offline
          Chris Maunder
          wrote on last edited by
          #15

          jmaida wrote:

          Are there any rules or restraints to posting code

          If it's yours, if you have the right to post it, if you feel it will be of value to someone, somewhere, then go for it! If it's small and is just a "here's how to do x' then maybe post it as a Tip rather than an Article (though either is fine)

          cheers Chris Maunder

          J 1 Reply Last reply
          0
          • C Chris Maunder

            Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

            cheers Chris Maunder

            D Offline
            D Offline
            David ONeil
            wrote on last edited by
            #16

            Easiest answer: move to the states! (Now might not be a good time, though.)

            Our Forgotten Astronomy | Object Oriented Programming with C++

            D 1 Reply Last reply
            0
            • D David ONeil

              Easiest answer: move to the states! (Now might not be a good time, though.)

              Our Forgotten Astronomy | Object Oriented Programming with C++

              D Offline
              D Offline
              Daniel Pfeffer
              wrote on last edited by
              #17

              Or leave the US (either solution works... :) )

              Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

              D 1 Reply Last reply
              0
              • D Daniel Pfeffer

                Or leave the US (either solution works... :) )

                Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

                D Offline
                D Offline
                David ONeil
                wrote on last edited by
                #18

                Not for his problem...

                Our Forgotten Astronomy | Object Oriented Programming with C++

                1 Reply Last reply
                0
                • C Chris Maunder

                  jmaida wrote:

                  Are there any rules or restraints to posting code

                  If it's yours, if you have the right to post it, if you feel it will be of value to someone, somewhere, then go for it! If it's small and is just a "here's how to do x' then maybe post it as a Tip rather than an Article (though either is fine)

                  cheers Chris Maunder

                  J Offline
                  J Offline
                  jmaida
                  wrote on last edited by
                  #19

                  I think I will look at your articles and tips format. Need to do a bit of research again on topic. It's been awhile. Thanx

                  "A little time, a little trouble, your better day" Badfinger

                  1 Reply Last reply
                  0
                  • C Chris Maunder

                    Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                    cheers Chris Maunder

                    O Offline
                    O Offline
                    obermd
                    wrote on last edited by
                    #20

                    Darn, and I wanted to use 1656806400000 ;P

                    1 Reply Last reply
                    0
                    • C Chris Maunder

                      Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                      cheers Chris Maunder

                      I Offline
                      I Offline
                      Indivara
                      wrote on last edited by
                      #21

                      I was under the impression that epoch dates were unambiguous until I came across those that weren't. Apparently there are so many different versions of those too :sigh: [Epoch (computing) - Wikipedia](https://en.wikipedia.org/wiki/Epoch\_(computing)) On a side note, "rationale for selection" on that page is blank for Unix epoch. I guess someone just pulled that year out of you-know-where :rolleyes:

                      C 1 Reply Last reply
                      0
                      • Greg UtasG Greg Utas

                        Visit Canada and you'll be disabused of the notion that the rest of the West hasn't allowed the insane to take over. Or New Zealand or Australia, for that matter. And that's not even mentioning the EU, which is almost beyond hope.

                        Robust Services Core | Software Techniques for Lemmings | Articles
                        The fox knows many things, but the hedgehog knows one big thing.

                        L Offline
                        L Offline
                        Leo56
                        wrote on last edited by
                        #22

                        What do you mean, "almost...."? The EU have been masters of insanity for decades... ;P

                        Greg UtasG 1 Reply Last reply
                        0
                        • C Chris Maunder

                          Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                          cheers Chris Maunder

                          M Offline
                          M Offline
                          Mike Winiberg
                          wrote on last edited by
                          #23

                          As I've said elsewhere hereabouts - in over 40 years of writing software, the handling of dates has been the biggest single problem I have had to tackle. It's staggering that after all these years, date handling is still a (mostly lost, incorrect and misunderstood) black art to almost all software systems, including date handling libraries, developer frameworks and just about every piece of end user software and web page you come across. 8(

                          G C 2 Replies Last reply
                          0
                          • M Mike Winiberg

                            As I've said elsewhere hereabouts - in over 40 years of writing software, the handling of dates has been the biggest single problem I have had to tackle. It's staggering that after all these years, date handling is still a (mostly lost, incorrect and misunderstood) black art to almost all software systems, including date handling libraries, developer frameworks and just about every piece of end user software and web page you come across. 8(

                            G Offline
                            G Offline
                            Gian Paolo
                            wrote on last edited by
                            #24

                            What about the war between point and comma as decimal/thousand separator? A joke comparing to dates war, but...

                            1 Reply Last reply
                            0
                            • C Chris Maunder

                              Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                              cheers Chris Maunder

                              R Offline
                              R Offline
                              RooN3y
                              wrote on last edited by
                              #25

                              Feel your pain with AWS. We have to set the culture code at the start of every Lambda we have because our main website sends dates in the british dd/mm/yyyy format and lambdas default to US format regardless of the region. The first 2 weeks of January where fun! I'm blaming AWS but to be honest it's probably the Linux image they use to spin up the lambda. But I don't want to blame Linux. Stupid AWS

                              C E 2 Replies Last reply
                              0
                              • C Chris Maunder

                                Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                                cheers Chris Maunder

                                G Offline
                                G Offline
                                GuyThiebaut
                                wrote on last edited by
                                #26

                                That's the tip of the iceberg. When you start getting to points in time and calculating between different points in time it becomes even more of a pain - then some developer decided to save dates without a timezone because "why would anyone ever need to know the timezone?" Dates are perhaps one of the biggest PITAs in data.

                                “That which can be asserted without evidence, can be dismissed without evidence.”

                                ― Christopher Hitchens

                                C 1 Reply Last reply
                                0
                                • L Leo56

                                  What do you mean, "almost...."? The EU have been masters of insanity for decades... ;P

                                  Greg UtasG Offline
                                  Greg UtasG Offline
                                  Greg Utas
                                  wrote on last edited by
                                  #27

                                  I'm an optimist at heart!

                                  Robust Services Core | Software Techniques for Lemmings | Articles
                                  The fox knows many things, but the hedgehog knows one big thing.

                                  <p><a href="https://github.com/GregUtas/robust-services-core/blob/master/README.md">Robust Services Core</a>
                                  <em>The fox knows many things, but the hedgehog knows one big thing.</em></p>

                                  1 Reply Last reply
                                  0
                                  • A Andreas Mertens

                                    Remember, this is the same country that is still using the English system of measures, when almost everywhere else we use the Metric system... It is as if there is a need to proclaim that they are not like anyone else, all the time....

                                    C Offline
                                    C Offline
                                    Charles Gallo
                                    wrote on last edited by
                                    #28

                                    At least we don't use stones for people, MPH for speed limits while distances are in Km

                                    A 1 Reply Last reply
                                    0
                                    • C Chris Maunder

                                      Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                                      cheers Chris Maunder

                                      G Offline
                                      G Offline
                                      gervacleto
                                      wrote on last edited by
                                      #29

                                      Absolutely, I agree. I alwys use '2022-07-03' OR '2022/07/03'. Different separator, same meaning.

                                      1 Reply Last reply
                                      0
                                      • C Chris Maunder

                                        Why is it that so many sites - the latest being AWS's portal - refuse to understand that the only country in the world that uses MM/DD as a date format is the US. OK, and Belize. And Canadians when they are being accomodating and polite. But no one else. The rest of the world is looking at 07/03 thinking "7th of March?". I honestly don't understand why companies do this other than they straight out don't realise no one else does does dates like this. I've banned ambiguous dates at CodeProject and DeveloperMedia because when we need to get dates nailed down and the conversation includes an American, a Canadian and an Australian (not walking into a bar) the conversation falls apart quickly if we can't trust the date that's been written on the contract. Can we please, each of us, take a quick look at our code and maybe, just maybe, rethink how dates are presented. Here are some options: - IF you're tight on space then 3Jul is better than 03/07 and 07/03. And sure, we then run into language issues, but if your site is predominately english then your readers have far bigger issues. - 2022-07-03 is universal. Everyone gets that, even SQL. - 3-Jul-2022 is friendly and obvious. 3-Jul-'22 is shorter if you really need s pace. - 1656806400000 is accurate, unambiguous, precise to the millisecond. And fairly useless. Don't do this.

                                        cheers Chris Maunder

                                        C Offline
                                        C Offline
                                        Cpichols
                                        wrote on last edited by
                                        #30

                                        American here. I agree that we need to resolve this date issue to something unambiguous, but I have a question:

                                        Quote:

                                        2022-07-03 is universal. Everyone gets that, even SQL.

                                        ... which is yyyy-mm-dd, right? Could/should we say that SQL is siding with the US on this one? I mean ... everyone adapts nicely to SQL dates, right?

                                        C 1 Reply Last reply
                                        0
                                        • P PIEBALDconsult

                                          ISO 8601 is the only true path. P.S. Do the Gerpeople still use 3.VII.2022 ?

                                          W Offline
                                          W Offline
                                          wapiti64
                                          wrote on last edited by
                                          #31

                                          ISO 8061 with offset from UTC FTW, time zone optional Actually, I find this thread hilarious bitching about US dates while recommending "Jul". Irony has no bounds.

                                          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