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. Why not an UN resolution for..

Why not an UN resolution for..

Scheduled Pinned Locked Moved The Lounge
saleshelpquestion
66 Posts 25 Posters 1 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.
  • J Jochen Arndt

    You do realise that you are talking about time spans now? Sorry for being pedantic here. I see your point but being an engineer and developer I have switched to the standardised formats long time ago even in "real" life (e.g. when signing papers requiring also the date). If you want to target users from all over the world, you have to use a general format understood by (hopefully) all of them. Everybody has to use something new from time to time. I'm not an American but understanding the ISO date format should be no problem compared with the changings to the metric system. As a developer you are free to provide such data in any or multiple formats. An example might be the posting dates here at CodeProject which are provided as time spans for short periods (hours ago, yesterday) and the date for older posts.

    J Offline
    J Offline
    Jon McKee
    wrote on last edited by
    #19

    Dates themselves are no more than a span of time relative to your current. The bigger question is who these time spans are important to. If it's a computer than UNIX time is superior to any of the aforementioned formats. If it's a human then you need to account for human ways in which they judge and measure the format. My argument is precisely that. It's slightly a goal-post move but to hit on the ISO mention: just because something exists doesn't inherently mean it's right. EDIT: Off-topic but it's worth mentioning that even though I use the Imperial System for measurement (you have to in the US), I actually vehemently agree with the Metric System being more reasonable.

    1 Reply Last reply
    0
    • T The pompey

      The most important part is the day. If you have an appointment on the 13th, then you need to know that it is tomorrow. If you think I have an appointment in June then you will likely miss it.

      J Offline
      J Offline
      Jon McKee
      wrote on last edited by
      #20

      If I have an appointment on the next Wednesday I don't need to know the absolute day, month, or year. It's tomorrow. EDIT: Actually in this specific case I see where you're coming from in that if you have an appointment in the future for, say 26/10, the day is important. But at the same time, a month is restricted by 12, a day by anywhere from 28-31. Wouldn't you rather know Wednesday in October (4 options) vs the 26th 4th week (12 options)?

      1 Reply Last reply
      0
      • OriginalGriffO OriginalGriff

        Some of it was profiteering, yes - but a lot was behind the scenes and wasn't. I spent a lot of time, effort, (and money) in late 90's making sure that all the systems in company I had just joined as Technical Manager (i.e. responsible for everything more complicated than a mains plug) were going to work on Jan 1st 2000, and replacing those that wouldn't. And that meant exhaustive testing on the Unix box that ran the company accounts (Accounts software: fail. Accounts system OS: fail. Accounts system hardware: Oh :Elephant:, Oh :Elephant:, Oh :Elephant:, fail, fail, fail. Can I get it back up by Monday?) followed by new software selection, implementation, data transfer, training, and parallel running as well as new software to produce management accounts summaries in a format they could understand. The reason very little failed on Jan 1 worldwide was that a huge amount of effort went into making sure they wouldn't ... :laugh:

        Sent from my Amstrad PC 1640 Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

        E Offline
        E Offline
        Eric Lynch
        wrote on last edited by
        #21

        I also ended up correcting a fair number of serious bugs in my company's software related to this issue. Regrettably, no profiteering on my part, since I was salary. Maybe next time, in the unlikely event its still necessary, when the original 32 bit Unix clock runs out in 2038 :)

        1 Reply Last reply
        0
        • E Eytukan

          standardizing the date formats and just keep it as one. The shorter, longer, the too longer all these differences are fine. I'm just talking about the completely opposite types like MM-DD-YY DD-MM-YY YY-MM-DD This is seriously freaking tiring to handle. All the data sheet exported from system are in MM-DD-YY format, and the customer read them all as DD-MM-YY & feeds into their own internal system. Yeah I head you saying "This is what localization is supposed to fix". But why? why not we fix this in peoples minds and make them follow a unified type. :sigh: :doh:

          Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.

          R Offline
          R Offline
          Rage
          wrote on last edited by
          #22

          The best convention is the number of seconds elapsed since 01.04.1972 : sssssssssssssssssssssssssss. No problem by export / import.

          Do not escape reality : improve reality !

          1 Reply Last reply
          0
          • L Lost User

            Because the 'mercans cannot handle the correct date (or time) formats. ;P

            W Offline
            W Offline
            W Balboos GHB
            wrote on last edited by
            #23

            Careful - the euro-standard is just uniformly ass-backwards. D-M-Y (any number of digits you prefer) sorts totally wrong. Period. YYYYMMDD is the only rational format as it can be sorted as is, even as text - but can be stored/sorted as an int. (I leave off proper date objects as they'd sort regardless). Just the usual Eurogance (the now and forever word for European arrogance). Time you just get over yourselves. Get some laxatives - clear your thoughts.

            Ravings en masse^

            "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

            "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

            D L K 3 Replies Last reply
            0
            • W W Balboos GHB

              Careful - the euro-standard is just uniformly ass-backwards. D-M-Y (any number of digits you prefer) sorts totally wrong. Period. YYYYMMDD is the only rational format as it can be sorted as is, even as text - but can be stored/sorted as an int. (I leave off proper date objects as they'd sort regardless). Just the usual Eurogance (the now and forever word for European arrogance). Time you just get over yourselves. Get some laxatives - clear your thoughts.

              Ravings en masse^

              "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

              "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

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

              W∴ Balboos wrote:

              Careful - the euro-standard is just uniformly ass-backwards.

              The Euro-standard sorts perfectly - if you write from right to left. :) You guys just need to learn Hebrew!

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

              W 1 Reply Last reply
              0
              • P PeejayAdams

                It was a fair bit of both, in truth. Yes, there was an awful lot of genuine work involved but equally there were an awful lot of "consultants" lining their pockets by spreading the fear. For my part, I did very well out of it working on a project for a very large organisation to temporarily migrate their ERP system for the two years across the millennium because SAP were reluctant to guarantee millennium compliance. Was that money well spent? I rather suspect that any problems arising from not doing it could have been sorted out by a bit of overtime for the finance team. Either way, I was rather glad that developers of yore were so short-sighted and/or strapped for disk-space!

                98.4% of statistics are made up on the spot.

                V Offline
                V Offline
                Vivi Chellappa
                wrote on last edited by
                #25

                I am surprised because SAP was touted as the solution to the Y2K problem in the US and was bought by many customers.

                P 1 Reply Last reply
                0
                • E Eytukan

                  standardizing the date formats and just keep it as one. The shorter, longer, the too longer all these differences are fine. I'm just talking about the completely opposite types like MM-DD-YY DD-MM-YY YY-MM-DD This is seriously freaking tiring to handle. All the data sheet exported from system are in MM-DD-YY format, and the customer read them all as DD-MM-YY & feeds into their own internal system. Yeah I head you saying "This is what localization is supposed to fix". But why? why not we fix this in peoples minds and make them follow a unified type. :sigh: :doh:

                  Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.

                  Richard DeemingR Offline
                  Richard DeemingR Offline
                  Richard Deeming
                  wrote on last edited by
                  #26

                  Obligatory XKCD[^]. :D


                  "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

                  "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

                  D 1 Reply Last reply
                  0
                  • V Vivi Chellappa

                    I am surprised because SAP was touted as the solution to the Y2K problem in the US and was bought by many customers.

                    P Offline
                    P Offline
                    PeejayAdams
                    wrote on last edited by
                    #27

                    As I remember it (and it does seem like an awful long time ago, now!), they were a bit slow off the mark in making any guarantees - at least in the UK. I'm pretty sure that they eventually did but by that time our client had already committed to take the route that they did - running through the timeline in my head, I suspect the decision was made sometime during 1995.

                    98.4% of statistics are made up on the spot.

                    1 Reply Last reply
                    0
                    • Richard DeemingR Richard Deeming

                      Obligatory XKCD[^]. :D


                      "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

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

                      I see you, and raise you [xkcd: ISO 8601](https://xkcd.com/1179/). No need for an additional standard. :)

                      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
                      • W W Balboos GHB

                        Careful - the euro-standard is just uniformly ass-backwards. D-M-Y (any number of digits you prefer) sorts totally wrong. Period. YYYYMMDD is the only rational format as it can be sorted as is, even as text - but can be stored/sorted as an int. (I leave off proper date objects as they'd sort regardless). Just the usual Eurogance (the now and forever word for European arrogance). Time you just get over yourselves. Get some laxatives - clear your thoughts.

                        Ravings en masse^

                        "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                        "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #29

                        I agree the Europeans are arrogant, but us British? ;)

                        W S 2 Replies Last reply
                        0
                        • D Daniel Pfeffer

                          W∴ Balboos wrote:

                          Careful - the euro-standard is just uniformly ass-backwards.

                          The Euro-standard sorts perfectly - if you write from right to left. :) You guys just need to learn Hebrew!

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

                          W Offline
                          W Offline
                          W Balboos GHB
                          wrote on last edited by
                          #30

                          Nachon - hakol b'seder. Or is that: .redes'b lokah - nohcaN

                          Ravings en masse^

                          "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                          "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                          1 Reply Last reply
                          0
                          • L Lost User

                            I agree the Europeans are arrogant, but us British? ;)

                            W Offline
                            W Offline
                            W Balboos GHB
                            wrote on last edited by
                            #31

                            OK OK OK. Having seen enough Midsomer Murders (&etc.), I can safely say 'pompous', rather than arrogant, would be the description.

                            Ravings en masse^

                            "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                            "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                            L 1 Reply Last reply
                            0
                            • W W Balboos GHB

                              OK OK OK. Having seen enough Midsomer Murders (&etc.), I can safely say 'pompous', rather than arrogant, would be the description.

                              Ravings en masse^

                              "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                              "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                              L Offline
                              L Offline
                              Lost User
                              wrote on last edited by
                              #32

                              W∴ Balboos wrote:

                              Midsomer Murders

                              There may even be somewhere in England where people really behave like that. Apart from the murdering perhaps. :)

                              W 1 Reply Last reply
                              0
                              • L Lost User

                                W∴ Balboos wrote:

                                Midsomer Murders

                                There may even be somewhere in England where people really behave like that. Apart from the murdering perhaps. :)

                                W Offline
                                W Offline
                                W Balboos GHB
                                wrote on last edited by
                                #33

                                From what I hear of the behavior (behaviour, to them) English school boys, it would be amazing if there were only three-per-show equivalent in the countryside. Or at the least, they'd pluck the limbs off the torsos. Famous, that lot.

                                Ravings en masse^

                                "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                                "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                                1 Reply Last reply
                                0
                                • E Eytukan

                                  standardizing the date formats and just keep it as one. The shorter, longer, the too longer all these differences are fine. I'm just talking about the completely opposite types like MM-DD-YY DD-MM-YY YY-MM-DD This is seriously freaking tiring to handle. All the data sheet exported from system are in MM-DD-YY format, and the customer read them all as DD-MM-YY & feeds into their own internal system. Yeah I head you saying "This is what localization is supposed to fix". But why? why not we fix this in peoples minds and make them follow a unified type. :sigh: :doh:

                                  Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.

                                  K Offline
                                  K Offline
                                  Kirill Illenseer
                                  wrote on last edited by
                                  #34

                                  The USA already don't give a damn about several international conventions. A unified date format would fall into the same pit.

                                  W 1 Reply Last reply
                                  0
                                  • J Jon McKee

                                    YYYY-MM-DD is great for historical context but not so great for day-to-day. When you read a date, what is the most important portion of that date to you? As someone who natively reads a left-to-right language, I believe the most critical portions should be farthest left. I know, currently, it's Tuesday where I live. Maybe I've been super busy for two weeks and missed that May rolled over into June. For me the most important portion is the month. With that single value alone I can immediately orient myself in time - Tuesday, early June, 2018. Viewing only the year, or only the day, can you claim the same? EDIT: I'm honestly curious (open discussion to anyone). I'm not set on any given methodology; this one just makes more sense to me. Anytime I bring up my reasoning in other discussions I'm dismissed as an American yet they provide no sensible argument to the contrary.

                                    W Offline
                                    W Offline
                                    W Balboos GHB
                                    wrote on last edited by
                                    #35

                                    If dates were alway yyyymmdd (with or without delimiters), it would not be a problem for left-to-right readers at all. Those of us who can read process so much information in the background that it will be adapted to as effortless. lkie radendg tihs - at lseat for nvtaie Enisglh uesrs.

                                    Ravings en masse^

                                    "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                                    "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                                    K 1 Reply Last reply
                                    0
                                    • K Kirill Illenseer

                                      The USA already don't give a damn about several international conventions. A unified date format would fall into the same pit.

                                      W Offline
                                      W Offline
                                      W Balboos GHB
                                      wrote on last edited by
                                      #36

                                      Right - because they don't follow the standards you prefer. Silly person!   China still doesn't have an alphabetic language and working on changing that would be time better spent (although they've had civil wars over that in the past). Let me remind you that the US use of 'ounces' is better for computers. 1 oz = base unit = 8 drams 4 oz = gil 8 oz = cup 16 oz = pint 32 oz = quart 128 oz = gallon All powers of two - perfectly represented in binary. Perhaps you ought to get over counting on your fingers and trash that roundoff-error-prone metric system.

                                      Ravings en masse^

                                      "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                                      "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                                      K 1 Reply Last reply
                                      0
                                      • W W Balboos GHB

                                        Careful - the euro-standard is just uniformly ass-backwards. D-M-Y (any number of digits you prefer) sorts totally wrong. Period. YYYYMMDD is the only rational format as it can be sorted as is, even as text - but can be stored/sorted as an int. (I leave off proper date objects as they'd sort regardless). Just the usual Eurogance (the now and forever word for European arrogance). Time you just get over yourselves. Get some laxatives - clear your thoughts.

                                        Ravings en masse^

                                        "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                                        "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                                        K Offline
                                        K Offline
                                        kalberts
                                        wrote on last edited by
                                        #37

                                        I certainly don't recognize what you are referring to, arguing in favor of yyyymmdd sort of as opposed to some "Eurogance". ISO 8601 has been adopted in Europe to a much higher degree than in the US, many years ago. Obviously, thirty years ago (when ISO 8601 was first published) there were other ways of writing dates. Some schemes were integrated in formal systems, such as the Norwegian "fødseslsnummer" (birth number, a rough equivalent to the social security number in the USA) where the person's ddmmyy birth date make up 6 of the 11 digits. When ISO 8601 was introduced, this 20+ year old scheme was not changed, and still remains. But for the great majority of new schemes established after 1988, the yyyy-mm-dd (with the hyphens, according to the international standard) format is used. Obviously, ISO 8601 was not out of the blue, either: The 8601 format was well known even before 1988. In informal contexts and particularly orally, other schemes (such as "thirteenth of June") is still in use. In formal contexts, ISO 8601 has a very strong position (unless old conventions must be followed, such as the fødselsnummer). Note that when Europeans do 8601, they do 8601: With the hyphens. Not as an 8-digit string. Not with slashes, but according to the international standard.

                                        W 1 Reply Last reply
                                        0
                                        • W W Balboos GHB

                                          If dates were alway yyyymmdd (with or without delimiters), it would not be a problem for left-to-right readers at all. Those of us who can read process so much information in the background that it will be adapted to as effortless. lkie radendg tihs - at lseat for nvtaie Enisglh uesrs.

                                          Ravings en masse^

                                          "The difference between genius and stupidity is that genius has its limits." - Albert Einstein

                                          "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

                                          K Offline
                                          K Offline
                                          kalberts
                                          wrote on last edited by
                                          #38

                                          One funny observation: We use "Arabic" numerals, reading left to right, reading the most significant digit first. In Arabic, they represent the numbers the same way, reading from right to left, reading the least significant digit first. In several European languages, including slightly archaic English, there are remains of least-to-most-significant reading: "four and twenty blackbirds". Even in modern German, you put the ones before the tens. In most Western languages, for the teens you put the ones before the ten: Four-teen, six-teen.

                                          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