?

Log in

No account? Create an account

Date formats

« previous entry | next entry »
Oct. 28th, 2010 | 04:51 pm
mood: awakeawake
music: diotrans - DDRMax Dance Dance Revolution Insomniac Skies OC ReMix

OK, I think now I've seen everything[1]:

Seriously, YYYY-DD-MM? What the heck? What is the point of that, other than to sow confusion? It doesn't have any nice properties (unlike, say, YYYY-MM-DD, for which the natural and lexicographic order coincide), it's not used in any culture, and it introduces ambiguousness where none existed before, bringing the problems with DD-MM-YYYY and MM-DD-YYYY to YYYY-MM-DD.

On that note, I really wish we'd all just use YYYY-MM-DD already and get rid of the rest. Myself, I've not been using anything else in at least half a decade myself (other than whan I slip and fall back to the traditional German DD-MM-YYYY, but that's a very rare occurrence nowadays); I don't expect everyone else to follow suit immediately, but at the very least, it'd be nice if people accomodated for international standards[2].

Anyhow, as far as Second Life is concerned, I'm mostly amused; it's just so absurd. :)

  1. Actually, I've seen this before, but chances are it was just a mistake then. Of course, chances are that it's just a mistake on the Second Life site, too, but they have much less of an excuse for not having caught this.

  2. 2. For example, a few years ago, when I wanted to book a train ticket through the Deutsche Bahn website, I found that they did not recognize YYYY-MM-DD dates at all, and when I got in touch with them and suggested that they rectify this (seeing as there was a standard), they told me that they were already aware of the issue but would not fix it. AAMOF, it still doesn't work now that I'm writing this, either.

Link | Leave a comment | Share

Comments {31}

Gryphe

(no subject)

from: gryphe
date: Oct. 28th, 2010 02:57 pm (UTC)
Link

Either way, I'm five months older then you! *Winks.*

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 28th, 2010 02:59 pm (UTC)
Link

You mean on SL? Probably a bit more, actually, since it's not my account. :) (My own dates from February 2006.)

Reply | Parent | Thread

moonhare

(no subject)

from: mondhasen
date: Oct. 28th, 2010 03:17 pm (UTC)
Link

"Seriously, YYYY-DD-MM? What the heck?"

That format is nicely confusing :o)

I name all my 'ghost' files for cloning using the YYYYMMDD_X format so that they'll appear in proper order when I call them up (_X is for multiples of the same ghost with minor variations: a, b, c, etc.). Of course, I could just dump the old ones and eliminate confusion, but I like redundancy in files so that if one fails I have a back-up.

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 28th, 2010 03:20 pm (UTC)
Link

It is, isn't it?

And redundancy is good. As they say:

  • Backup all your data
  • Backup frequently
  • Take some backups off-site
  • Keep some old backups
  • Test your backups
  • Secure your backups
  • Perform integrity checking

I'll admit I'm guilty of not following all these to the extent that I should (far from it, in some cases), but they're good rules to keep in mind and aspire to.

Reply | Parent | Thread | Expand

Natasha Softpaw

(no subject)

from: natashasoftpaw
date: Oct. 28th, 2010 04:22 pm (UTC)
Link

I actually always use Mmm DD, YYYY (ie, Oct 28, 2010), it's not that much longer than the shortened formats, and there's no abiguity at all. Having grown up in the US, I have a hard time putting the D before the M, regardless of how it's written, but doing it this way, I can at least prevent people from getting confused over dates like June 11th :-P

Despite being a US native (a country that seems to celebrate saying "fuck you" to international standards), I try to be as internationally-minded as possible, avoiding ambiguity in dates, times, measurements, and general speech whenever I can :-D

...Having written this comment, it occurs to me that people who don't know any English could get confused over this, depending on what their month names are in their language, but at least there's no confusion over which part is the day and which part is the month. Plus, it's extremely rare that I'd ever have any reason for someone who speaks no English at all to read a date I've written; I honestly can't think of a situation where that would be a problem.

Also, my old SL account is almost exactly a year older than you, it was created December 21, 2004 :-)

Reply | Thread

Storm Cloud

(no subject)

from: shadow_stallion
date: Oct. 28th, 2010 05:24 pm (UTC)
Link

I actually prefer this to any other method for exactly the reasons you mention. There is no question as to what date you are referring to. :D

If I were to use only numbers then I am accustomed to to seeing DD/MM/YYYY. Any format other than that just looks awkward to me but I can understand that we are just different and accustomed to a different format from the rest of the world.

It really gets confusing when some people try to shorten the year to only two numbers. >.

Reply | Parent | Thread | Expand

Lucius

(no subject)

from: ducktapeddonkey
date: Oct. 28th, 2010 07:57 pm (UTC)
Link

I'm with you on picking one date format and just sticking with that.

I'm always fighting with dates in Excel at work. Sometimes you can't even switch it back to the right format if it's been messed up well enough.

MM DD YYYY makes sense since that's how most people would say the date. October 28th, 2010.

But that doesn't sort too well in a computer once you start spanning multiple years. So YYYY MM DD makes more sense there.

What's really annoying though is that Windows will start messing with your date format depending on the "localization" you choose. More than once this has seriously messed up some big spreadsheets.

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 28th, 2010 08:48 pm (UTC)
Link

MM DD YYYY makes sense since that's how most people would say the date. October 28th, 2010.

But you could also say "28th of October, 2010". :) (In fact, that's how you'd say it in German – "28. Oktober 2010" –, and why it's DD-MM-YYYY in German.)

Yeah, automatically changing these things depending on the users locale is troublesome, though. I can understand the motivation, but I think it's bad trade-off: it's making things easier for about five minutes in exchange for (metaphorical) headaches that'll stay with you forever.

My personal pet peeve is the decimal point and thousands separator, BTW. In English, you'd write "1,000.00"; in German, this'd traditionally be rendered as "1.000,00" instead. It's particularly annoying on sites like eBay that DO make this distinction based on what localized site you're on.

(In fact, in the past eBay happily handled this the dumbest possible way and converted a bid of "10,00" on eBay.com or "10.00" on eBay.de to a thousand USD/EUR, respectively. Nowadays, they seem to catch it as an "invalid amount", at least...)

Reply | Parent | Thread | Expand

Killjoy #10

(no subject)

from: lionhill
date: Oct. 28th, 2010 08:51 pm (UTC)
Link

I for my part veru much prefer the DD-MM-YYYY format. It think it's more logical that the "smaller" number in the counter, so to speak, is in the front and then organized from that.

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 28th, 2010 08:57 pm (UTC)
Link

That's true, but it's still ambiguous once you encounter dates written by people from the USA. :)

Reply | Parent | Thread

tzisorey

(no subject)

from: tzisorey
date: Oct. 28th, 2010 10:15 pm (UTC)
Link

Just wait 'til someone comes out with DD-YYYY-MM - all the confusion of MM-YYYY-DD, but half as lexically sortable ;)

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 28th, 2010 10:19 pm (UTC)
Link

*shudders*

Well, at least it won't be DYMYMDYY or so. x.x

Reply | Parent | Thread

Sandwalker

(no subject)

from: greytail
date: Oct. 29th, 2010 10:38 am (UTC)
Link

We here in NZ use DD/MM/YY(YY), though sometimes I write Mmm DD, YYYY. When I had to work with databases in my classes, we found that the database would accept dates in our format, but when dates were retrieved they'd come out as MM/DD/YYYY -- getting them out in DD/MM/YYYY order required fiddling with some settings.

Reply | Thread

Schneelocke

(no subject)

from: schnee
date: Oct. 29th, 2010 10:49 am (UTC)
Link

*noddles* MySQL?

And interesting; I was taught that the entire English-speaking world used MM/DD/(YY)YY, but apparently, it's not actually true, with neither the Britons nor the Kiwis actually doing so. *s*

Reply | Parent | Thread | Expand

(Deleted comment)

Schneelocke

(no subject)

from: schnee
date: Oct. 29th, 2010 04:11 pm (UTC)
Link

*noddles* MM-DD-YYYY is pretty odd for similar reasons, but at least one can claim that it's traditional. *s*

Dates like "2005, 24 Mar" are very weird indeed, though — and only slightly less so than an outright "2005-24-03".

Reply | Parent | Thread