Best date format?

Page 3 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.

Howard

Lifer
Oct 14, 1999
47,982
10
81
Originally posted by: Fenixgoon
Originally posted by: joshsquall
MM/DD/YYYY. It's how we speak. March 12th, 2008 sounds much better than 12th March, 2008 or 2008, March 12th.
There's no need to pronounce (or transliterate, whatever) each number as it comes. Once you get used to any format it becomes second nature to interpret.
 

Gunslinger08

Lifer
Nov 18, 2001
13,234
2
81
Originally posted by: Howard
Originally posted by: Fenixgoon
Originally posted by: joshsquall
MM/DD/YYYY. It's how we speak. March 12th, 2008 sounds much better than 12th March, 2008 or 2008, March 12th.
There's no need to pronounce (or transliterate, whatever) each number as it comes. Once you get used to any format it becomes second nature to interpret.

Why use a date format that can't immediately be translated into words?
 

shortylickens

No Lifer
Jul 15, 2003
80,287
17,079
136
The best date format is as follows:
FMF

MFF is nice too, as is MF FF, but FMF is the best format for a date.
 

sunzt

Diamond Member
Nov 27, 2003
3,076
3
81
YY/MM/DD

General to specific details, just like how most problems are addressed. More logical too.
 

sdifox

No Lifer
Sep 30, 2005
96,959
16,212
126
There is no way to fuck up yyyy-mm-dd, unlike any other format. I don't get why we are still using the other numeric ones. If you are spelling out the month, sure, use mm/dd/yyyy, but otherwise, please, use yyyy-mm-dd
 

sdifox

No Lifer
Sep 30, 2005
96,959
16,212
126
Originally posted by: joshsquall
Originally posted by: Howard
Originally posted by: Fenixgoon
Originally posted by: joshsquall
MM/DD/YYYY. It's how we speak. March 12th, 2008 sounds much better than 12th March, 2008 or 2008, March 12th.
There's no need to pronounce (or transliterate, whatever) each number as it comes. Once you get used to any format it becomes second nature to interpret.

Why use a date format that can't immediately be translated into words?

because ambiguity in dates fucks up a lot of things, especially in banking.
 

Mermaidman

Diamond Member
Sep 4, 2003
7,987
93
91
Originally posted by: ironwing
2008_03_12

Easy to read, sortable, appropriate for file and folder names. When used as files names format is self sorting.

//Porn/oldsmoboat_butt_ass_nekid_2008_03_11.jpg
//Porn/oldsmoboat_butt_ass_nekid_2008_03_12.jpg
Only one pic a day?
 

Howard

Lifer
Oct 14, 1999
47,982
10
81
Originally posted by: joshsquall
Originally posted by: Howard
Originally posted by: Fenixgoon
Originally posted by: joshsquall
MM/DD/YYYY. It's how we speak. March 12th, 2008 sounds much better than 12th March, 2008 or 2008, March 12th.
There's no need to pronounce (or transliterate, whatever) each number as it comes. Once you get used to any format it becomes second nature to interpret.

Why use a date format that can't immediately be translated into words?
12MAR08, 30-08-2008... Not everybody uses 01-30-2008.
 

sjwaste

Diamond Member
Aug 2, 2000
8,757
12
81
Originally posted by: FoBoT
not out of all of them, if you include non-numeric only, then i prefer

12 MAR 2008

I spent enough time as a SAS programmer to apprecate the DATE9. format
 

sandorski

No Lifer
Oct 10, 1999
70,231
5,807
126
dd/mm/yyyy is the more practical, but yyyy/mm/dd is not bad. mm/dd/yyyy makes little sense and is the reason why people get confused when reading other peoples Dates. mm/dd/yyyy would be like giving the Time as mm/HH/ss.
 

Babbles

Diamond Member
Jan 4, 2001
8,253
14
81
Originally posted by: FoBoT
not out of all of them, if you include non-numeric only, then i prefer

12 MAR 2008

I work in the pharmaceutical research industry and I would go so far as to say that this is, for the most part, the scientific standard for writing the date. Granted not everybody and every company out there uses it, but for the most part this seems standard. Many people, and I do as well at times, will use MM/DD/YY but again when it comes to more formal date writing the 12-Mar-2008 type format seems to be the most common.
 

jagec

Lifer
Apr 30, 2004
24,442
6
81
Originally posted by: joshsquall
Originally posted by: Howard
Originally posted by: Fenixgoon
Originally posted by: joshsquall
MM/DD/YYYY. It's how we speak. March 12th, 2008 sounds much better than 12th March, 2008 or 2008, March 12th.
There's no need to pronounce (or transliterate, whatever) each number as it comes. Once you get used to any format it becomes second nature to interpret.

Why use a date format that can't immediately be translated into words?

Because dates are numbers, and this way it sorts properly in every single computer system. Humans are better at compensating than computers, so if anything we should be the ones who rearrange between written dates and spoken words.
 

Babbles

Diamond Member
Jan 4, 2001
8,253
14
81
Originally posted by: sandorski
dd/mm/yyyy is the more practical, but yyyy/mm/dd is not bad. mm/dd/yyyy makes little sense and is the reason why people get confused when reading other peoples Dates. mm/dd/yyyy would be like giving the Time as mm/HH/ss.

I think you are blowing it out of proportion. I would say that most people (at least in the USA) verbally say the date as something like, "March 12." Then along those lines people do have a tendency to write in a similar manner that they speak, therefore to write the date as mm/dd/yyyy mimics how many people speak.

Makes reasonable sense, regardless if you like it or not.
 

GeekDrew

Diamond Member
Jun 7, 2000
9,099
19
81
Depends on where it is being used.

Never - absolutely never - (mm/dd/yy), (mm/dd/yyyy), (dd/mm/yy), (dd/mm/yyyy).

Usually, when using the date in a text field that is not directly recorded as 'data', or when handwriting, I'll use (12 MAR 2008), and drop the year if I'm 100% certain that it does not matter, even if the receiver of said communication manages to foul up the year.

If it is in any kind of electronic/data format, then definitely by order from greatest unit to smallest, dropping units from the end when they are not significant (or worse yet, detrimental) to the application:

YYYYMMDDTHHMMSSZ - 20080312T195701Z
or, if you want it to be human-readable,
YYYY-MM-DDTHH:MM:SS Z - 2008-03-12T19:57:01 Z

When recording hours, I definitely prefer 24 hour (military/international) format. If the people aren't bright enough to figure that out, then 12 hour with AM/PM indicated. If AM/PM isn't indicated in 12 hour format, then recording the timebit is altogether worthless.
 

sandorski

No Lifer
Oct 10, 1999
70,231
5,807
126
Originally posted by: Babbles
Originally posted by: sandorski
dd/mm/yyyy is the more practical, but yyyy/mm/dd is not bad. mm/dd/yyyy makes little sense and is the reason why people get confused when reading other peoples Dates. mm/dd/yyyy would be like giving the Time as mm/HH/ss.

I think you are blowing it out of proportion. I would say that most people (at least in the USA) verbally say the date as something like, "March 12." Then along those lines people do have a tendency to write in a similar manner that they speak, therefore to write the date as mm/dd/yyyy mimics how many people speak.

Makes reasonable sense, regardless if you like it or not.

Ya, it does mimmick how people who speak English say the Date. However, when people tell the date they usually speak the Month as a word and not numerically. This is where the confusion comes in with written Numerical Dates. You don't say the word, but a number representative of a Month within a Year.

The problem also becomes apparent when people of other languages read the Numerical Date. They often do not verbally say mm/dd, so not only would they possibly be confused as to what you wrote, but you may also be confused as to what they wrote.

Mathematically denoted things should follow a Logical and a universally understandable pattern. MM/DD/YYYY doesn't comply with that.
 

IronWing

No Lifer
Jul 20, 2001
70,220
28,919
136
We should ask ourselves "How would Larry Wall write it?" and adopt 2008_02_12 for March 12th, 2008.
 

Sunner

Elite Member
Oct 9, 1999
11,641
0
76
YYYYMMDD, put whatever delimiters you like between them.

Messing it up by putting it in a completely illogical order in terms of unit "size" never made any sense to me
And the "That's the way you say it" doesn't make any more sense to me than people saying the imperial system is good "because you can relate to a foot, what the hell is a meter?".
 
May 16, 2000
13,522
0
0
Absolutely ass backwards for anything important.

DD/MM/YYYY

From smallest to largest. I don't know why, but my brain just won't wrap the other direction.
 

EKKC

Diamond Member
May 31, 2005
5,895
0
0
filenames i prefer YYYYMMDD
writing i would still do MM/DD/YYYY
 
sale-70-410-exam    | Exam-200-125-pdf    | we-sale-70-410-exam    | hot-sale-70-410-exam    | Latest-exam-700-603-Dumps    | Dumps-98-363-exams-date    | Certs-200-125-date    | Dumps-300-075-exams-date    | hot-sale-book-C8010-726-book    | Hot-Sale-200-310-Exam    | Exam-Description-200-310-dumps?    | hot-sale-book-200-125-book    | Latest-Updated-300-209-Exam    | Dumps-210-260-exams-date    | Download-200-125-Exam-PDF    | Exam-Description-300-101-dumps    | Certs-300-101-date    | Hot-Sale-300-075-Exam    | Latest-exam-200-125-Dumps    | Exam-Description-200-125-dumps    | Latest-Updated-300-075-Exam    | hot-sale-book-210-260-book    | Dumps-200-901-exams-date    | Certs-200-901-date    | Latest-exam-1Z0-062-Dumps    | Hot-Sale-1Z0-062-Exam    | Certs-CSSLP-date    | 100%-Pass-70-383-Exams    | Latest-JN0-360-real-exam-questions    | 100%-Pass-4A0-100-Real-Exam-Questions    | Dumps-300-135-exams-date    | Passed-200-105-Tech-Exams    | Latest-Updated-200-310-Exam    | Download-300-070-Exam-PDF    | Hot-Sale-JN0-360-Exam    | 100%-Pass-JN0-360-Exams    | 100%-Pass-JN0-360-Real-Exam-Questions    | Dumps-JN0-360-exams-date    | Exam-Description-1Z0-876-dumps    | Latest-exam-1Z0-876-Dumps    | Dumps-HPE0-Y53-exams-date    | 2017-Latest-HPE0-Y53-Exam    | 100%-Pass-HPE0-Y53-Real-Exam-Questions    | Pass-4A0-100-Exam    | Latest-4A0-100-Questions    | Dumps-98-365-exams-date    | 2017-Latest-98-365-Exam    | 100%-Pass-VCS-254-Exams    | 2017-Latest-VCS-273-Exam    | Dumps-200-355-exams-date    | 2017-Latest-300-320-Exam    | Pass-300-101-Exam    | 100%-Pass-300-115-Exams    |
http://www.portvapes.co.uk/    | http://www.portvapes.co.uk/    |