• QuantumEraser@fedia.ioOP
      link
      fedilink
      arrow-up
      2
      ·
      15 hours ago

      Yeah sorry about that, was the default format in my spreadsheet software and I didn’t think to change it

        • calcopiritus@lemmy.world
          link
          fedilink
          arrow-up
          5
          ·
          17 hours ago

          I wish. Am European. I know one person that voluntarily uses their date and time formats. For reasons I will never comprehend.

          • Jiral@lemmy.world
            link
            fedilink
            arrow-up
            5
            ·
            17 hours ago

            He or she must enjoy the endless confusion and friction in the interaction with others. That said, some idiotic IT systems use the US format to. Causes a lot of problems.

            • Laurel Raven@lemmy.zip
              link
              fedilink
              English
              arrow-up
              3
              ·
              11 hours ago

              I’m in the US and have had problems with C-level douches misreading dd-mm-yyyy dates in some system we had that logged in that format and freaking out (and also missing that the log time stamps were in UTC-0, causing further confusion/freakout)

              Anyway, this is part of why I always use yyyy-mm-dd, because nobody will confuse that date string for any other date, and everyone who can understand dates at all will be able to read it.

          • glimse@lemmy.world
            link
            fedilink
            arrow-up
            19
            ·
            edit-2
            17 hours ago

            NO. You need a character per digit and you always want the leading 0 shown.

            YYYY-MM-DD

                  • Pup Biru@aussie.zone
                    link
                    fedilink
                    English
                    arrow-up
                    4
                    ·
                    16 hours ago

                    you should never make the assumption that software you use is smart, or even not complete garbage

                    …and file managers aren’t the only things that display lists of files. low-level tooling should not be “smart” beyond the most basic sorting without specifically being told first

                  • glimse@lemmy.world
                    link
                    fedilink
                    arrow-up
                    2
                    ·
                    15 hours ago

                    …And you assume you will only ever look at those files with that file manager forever…

                    There is no downside to writing the leading zeroes pretty much anywhere except when aesthetics matter (event flyers, etc)

            • palordrolap@fedia.io
              link
              fedilink
              arrow-up
              3
              ·
              10 hours ago

              It’s close, sure, but actually no. That standard currently requires the letter T (and no white-space) between date and time when both are present, and, frankly, that’s ugly and a space should be allowed.

              An old version of the standard allowed the space, and GNU’s coreutils seem to have carried on the tradition, so I’m not alone in thinking this.

            • zqps@sh.itjust.works
              link
              fedilink
              arrow-up
              6
              ·
              17 hours ago

              No because it’s the global format that typically uses periods.

              D.M.Y (normal)
              Y-M-D (superior)
              M/D/Y (mental illness)

              Mixing up the formats and denominators makes this mess even worse.

              • Pup Biru@aussie.zone
                link
                fedilink
                English
                arrow-up
                2
                ·
                16 hours ago

                you should also always specify YYYY-MM-DD because often M and D ignores leading zeros, YY means the 2 digit suffix, and Y… well, i don’t even know what that is but i’m sure it’s something less specific than YYYY

                if we’re going to be picky about being clear about things, let’s be truly clear about things

                • Laurel Raven@lemmy.zip
                  link
                  fedilink
                  English
                  arrow-up
                  2
                  ·
                  11 hours ago

                  YYYYY would be something like “The Year of Our Lord, Two-Thousand and Twenty-Six” (or probably just “Twenty Twenty-Six”, but the other is more ridiculous so I’ll go with that)

                  Y would just be “6” but I can’t think of any context where that would ever be used

                  • Pup Biru@aussie.zone
                    link
                    fedilink
                    English
                    arrow-up
                    2
                    ·
                    5 hours ago

                    i reckon Y might be something like years since 1970 or some other epoch (we do things like week number of the year, day number of the year, etc so i think that’s kinda similar)