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 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.
  • 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
                                        • 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

                                          S Offline
                                          S Offline
                                          Slow Eddie
                                          wrote on last edited by
                                          #32

                                          The reason is that habits are hard things to break. :( Americans have fallen into using those things out of long developed habits involving these things. Besides that, the monetary cost of switching to these things, as you are suggesting, would be mind-bogglingy huge. Our economy would go into a depression causing a world-wide depression. So, you see we are doing it for your own good. Just because something is popular, doesn't make it right or good. :-D Lastly, if you all went and jumped off a bridge, killing yourselves, should we do the same? :confused::confused::confused:

                                          Yodles!

                                          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