Why, in the USA, do we use MM/DD/YYYY when most of the world uses DD/MM/YYYY? The latter seems to be more logical, but I could never give up the former. Someone help.
I get a lot of Techno and House DJ sets off of the net- a lot of which are from Europe, and I can never tell which is the month or the day if both are 12 or under.
The only really logical format is YYYY/MM/DD, which I came to understand after working with computer files.
As to the OP, Americans write the month first because after all we’re used to speaking it that way. Today is March 22, 2002. That’s the way that feels natural and easy to say.
I have heard a few BBC types who will say “Twenty-second March” out loud, but to my ears that sounds affected and slightly bizarre. It also sounds (logically) like the 22nd in a series of Marches, like “This is the 22nd March since 1980 that there hasn’t been a snowfall!”
The old-fashioned Continental Europeans had a good habit, which was always to write the month in Roman numerals and the rest in Arabic numerals. That way you would understand with no ambiguity that 3.III.33 meant the third of March, (19)33.
Jomo Mojo
2002.III.22
Thanks guys. I found this thread http://boards.straightdope.com/sdmb/showthread.php?threadid=73191&highlight=dd%2Fmm%2Fyyyy right after I started mine.
YYYY/MM/DD may be logical for some applications, but for day to day living it is a bit long winded. I find myself asking what day it is far more than what year.
Interesting. Around here, it appears most people would say, “today is the 22nd of March 2002”, which fits the format 22/03/2002. Sounds pretty natural to me.
This is from memory, so please allow that.
I recall reading that the country we now call the United States conformed to standard dating practices for most of its early years.
The U.S. method of dating things can be traced to one single document that was reprinted multiple times:
July 4, 1776.
That one document set a standard that is still in use.
Today in Japan, its H14.3.22
The fourteenth year of the reign of the Heisei emperor, the third month, and the 22nd day.
There’s a bit of useless trivia for you!
That’s because they omit the word of “The 22nd of March” makes perfect sense, but like you said, you say it your way, we say it ours.
It’s not unlike the difference between saying “eight twenty” and “twenty past eight”.
Interestingly enough, this is, in fact, the way Hungarians write their dates.
This is also a huge problem in computer programming; for example there are situations in which Microsoft access will get confused if the day is less than the 13th (or it does here in the UK; is suspect if your local time format is the same as the US standard, it will work fine - I believe that part of it is that in SQL, dates are supposed to be mm/dd/yy regardless of who or where you are).
The YYYYMMDD system is also used in Sweden.
And as it is the ISO standard (number 8601-2000) I use it whenever I can, wherever I am.
Mangetout, if you set your database server’s regional settings to dd/mm/yyyy, and make sure your ODBC connections are set to “British English” rather than just “English”, you can, in fact, store and retrieve dates in that format in MS SQL server. I forget the exact steps required to do the same for Access, but, if beaten, threatened and abused in the right manner, it too can be made to comply.
(Thus sayeth Steve, who has devoted significant portions of his life to getting dates out of American format and into databases.)
I’m fairly sure BBC types don’t actually say this: they would say “Twenty-second of March” - which makes perfect sense to my (English) ears.
I think Jomo may have been referring to Americans who have adopted British affectations, rather than British natives.
In Britain, the date is written “22 March” or “22nd March”, but if you read that aloud you would say “the twenty-second of March”. In speech, “March the twenty-second” would be acceptable but, oddly enough, to write “March 22” would be regarded as an Americanism.
The default format for SQL is set by the database system administrator. The last system I used had MM/DD/YYYY set. There’s also a MM/DD/RR format, where the RR is interpreted as being either in the 1900’s or the 2000’s, depending on another system administrator’s setting. Before Y2K (remember that?), we used 25 as the dividing line; i.e., RR=25 to 99 meant 1925 to 1999, and 00 to 24 meant 2000 to 2024.
Thanks for the SQL everyone, but I’m not using a server back-end at the mo; just the MS Jet engine, which (as far as I can tell) is not very configurable.
I don’t do much developing in Access/VB nowadays anyway as my current company favours Delphi/Interbase.
Then surely the Fourth of July breaks this rule. Any idea why?
It’s called an exception.