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. A new date standard?

A new date standard?

Scheduled Pinned Locked Moved The Lounge
csharpjavascriptdatabaselinqcom
49 Posts 19 Posters 2 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.
  • L Lost User

    How many orders did you put on that date? :)

    Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

    Sander RosselS Offline
    Sander RosselS Offline
    Sander Rossel
    wrote on last edited by
    #5

    None, I got the hell out of there :laugh:

    Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

    L M 2 Replies Last reply
    0
    • D Daniel Pfeffer

      There's an RFC for that... [RFC 2550 - Y10K and Beyond](https://tools.ietf.org/html/rfc2550) :laugh:

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

      Sander RosselS Offline
      Sander RosselS Offline
      Sander Rossel
      wrote on last edited by
      #6

      That's a whole lot of words for "add another digit" :rolleyes:

      Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

      D 1 Reply Last reply
      0
      • Sander RosselS Sander Rossel

        So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

        Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

        Mike HankeyM Offline
        Mike HankeyM Offline
        Mike Hankey
        wrote on last edited by
        #7

        1 BCE?

        I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!

        Sander RosselS K 2 Replies Last reply
        0
        • Mike HankeyM Mike Hankey

          1 BCE?

          I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!

          Sander RosselS Offline
          Sander RosselS Offline
          Sander Rossel
          wrote on last edited by
          #8

          Unless they're using the Xiqorcian calendar :)

          Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

          Mike HankeyM 1 Reply Last reply
          0
          • Sander RosselS Sander Rossel

            Unless they're using the Xiqorcian calendar :)

            Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

            Mike HankeyM Offline
            Mike HankeyM Offline
            Mike Hankey
            wrote on last edited by
            #9

            Or Mayan calendar which would be 7.17.18.10.10

            OriginalGriffO 1 Reply Last reply
            0
            • Sander RosselS Sander Rossel

              That's a whole lot of words for "add another digit" :rolleyes:

              Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

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

              Sander Rossel wrote:

              "add another digit"

              ...only when necessary!

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

              P 1 Reply Last reply
              0
              • Sander RosselS Sander Rossel

                None, I got the hell out of there :laugh:

                Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

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

                Just place as much orders for that date as possible. Stuff from this era will be worth a lot by then, and you have time enough to save for the bill :thumbsup:

                Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                1 Reply Last reply
                0
                • Mike HankeyM Mike Hankey

                  Or Mayan calendar which would be 7.17.18.10.10

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

                  Isn't that an IP address? :laugh:

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

                  "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

                  Mike HankeyM G 2 Replies Last reply
                  0
                  • OriginalGriffO OriginalGriff

                    Isn't that an IP address? :laugh:

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

                    Mike HankeyM Offline
                    Mike HankeyM Offline
                    Mike Hankey
                    wrote on last edited by
                    #13

                    WouldntYaWantToBeAMayan.com I believe?

                    I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!

                    L 1 Reply Last reply
                    0
                    • Mike HankeyM Mike Hankey

                      WouldntYaWantToBeAMayan.com I believe?

                      I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!

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

                      MostSanePeopleDoNotWantToBeExtinct.org

                      Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                      1 Reply Last reply
                      0
                      • D Daniel Pfeffer

                        Sander Rossel wrote:

                        "add another digit"

                        ...only when necessary!

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

                        P Offline
                        P Offline
                        PIEBALDconsult
                        wrote on last edited by
                        #15

                        By mutual agreement of the partners in the interchange?

                        1 Reply Last reply
                        0
                        • Sander RosselS Sander Rossel

                          So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                          Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                          P Offline
                          P Offline
                          PIEBALDconsult
                          wrote on last edited by
                          #16

                          ISO 8601 or go home.

                          1 Reply Last reply
                          0
                          • Sander RosselS Sander Rossel

                            So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                            Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

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

                            Quote:

                            for Americans, that's the logical order of day-month--year

                            :confused: What I think to remember and described here "In the United States, dates are traditionally written in the "month-day-year" order: Date and time notation in the United States - Wikipedia[^]

                            It does not solve my Problem, but it answers my question

                            1 Reply Last reply
                            0
                            • Sander RosselS Sander Rossel

                              So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                              Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                              R Offline
                              R Offline
                              Rick York
                              wrote on last edited by
                              #18

                              Could this be a date in the past that is being subtracted resulting in a negative year? In other words, could the year be a -1?

                              1 Reply Last reply
                              0
                              • Sander RosselS Sander Rossel

                                None, I got the hell out of there :laugh:

                                Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                M Offline
                                M Offline
                                Mycroft Holmes
                                wrote on last edited by
                                #19

                                Sander Rossel wrote:

                                I got the hell out of there

                                What you don't trust a site that stores it's dates a strings?

                                Never underestimate the power of human stupidity RAH

                                1 Reply Last reply
                                0
                                • Sander RosselS Sander Rossel

                                  So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                                  Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

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

                                  https://xkcd.com/927

                                  1 Reply Last reply
                                  0
                                  • OriginalGriffO OriginalGriff

                                    Isn't that an IP address? :laugh:

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

                                    G Offline
                                    G Offline
                                    Greg Mavhunga
                                    wrote on last edited by
                                    #21

                                    Its an IP address of a point in time! :laugh: :laugh: :laugh:

                                    1 Reply Last reply
                                    0
                                    • Sander RosselS Sander Rossel

                                      So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                                      Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                      J Offline
                                      J Offline
                                      Joop Eggen
                                      wrote on last edited by
                                      #22

                                      This is format dd-MM-uuuu, where the year may be negative: -1 here, as opposed to yyyy. Maybe a hotel reservation in Bethlehem.

                                      1 Reply Last reply
                                      0
                                      • Sander RosselS Sander Rossel

                                        So I'm at this web shop and they have a product which is expected on "30-11--0001" (for Americans, that's the logical order of day-month--year). That's a pretty weird date, I'd expect 01-01-0001 or 01-01-1970 or even 01-01-1753 (the SQL min value), but never 30-11... The extra dash between the month and the year bothers me too, that's not a standard notation anywhere as far as I know. The best part though, is that I can pre-order the product, so apparently 30-11--0001 is a date in the future! And to make it worse, it's a best selling product, so they've already sold plenty. I can only draw one conclusion from all of this: this web shop is centuries, if not millennia, ahead of us (or at least they serve time travellers)! :omg: Is your software Y10K proof? :rolleyes:

                                        Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

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

                                        Sander Rossel wrote:

                                        (for Americans, that's the logical order of day-month--year).

                                        That's the typical Eurocentric ass-backwards mindset. YYYYMMDD, with whatever delimiters float you boat. As for the US Vernacular, most conversations would say something like October 25th or June 2nd. The year is only necessary, in conversations, a fraction of the time. So - the dates are written as they are said. But, as far as it goes, it's no worse for sorting (even when numeric) than the crappy Euro-convention. At least, if all in the same year, the US convention MM-DD would sort correctly (small consolation).

                                        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 Sander RosselS 2 Replies Last reply
                                        0
                                        • Mike HankeyM Mike Hankey

                                          1 BCE?

                                          I may not be that good looking, or athletic, or funny, or talented, or smart I forgot where I was going with this but I do know I love bacon!

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

                                          Mike Hankey wrote:

                                          1 BCE?

                                          or maybe 2 BCE? When Y2K was a hot topic, I was surprised to learn that the church (at least the protestant ones, but I assume that catholic ones agree, and then the other (Christian) ones follow suit) have a discontinuous time line: Year 1 BC is immediately followed by year 1 AD, with no intermediate year 0. So the question is if the time format used here has a year 0. We must assume that value 1 is AD (or if you like: CE), but is a value of 0 then 1 BC, and a value of -1 consequently 2 BC? Or is value 0 illegal? I was surprised to read in Wikipedia that the numerical value of AD/BC and CE are identical, with "400 BCE corresponds to 400 BC" explicitly given as an example. So the CE concept has adopted a discontinuous number line for labeling years. It is kind of curious that in an attempt to mark an independence from religion defined time scales, still we stick to a highly religion defined number line, rather than a mathematical one. Maybe it has to do with the zero being invented by the Arabs, and as we all know, their culture is not quite as we want it to be, so we reject it. What I am now waiting for is some (secular) standard that requires 1 = 3.

                                          Mike HankeyM I 2 Replies 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