RE: re[2]: MYSQL Date Format - Tim Endres - com.mysql.lists.win32

2 messages in com.mysql.lists.win32RE: re[2]: MYSQL Date Format

From	Sent On	Attachments
Public Folder: MySQL	19 Mar 2003 08:42
Tim Endres	19 Mar 2003 11:11

Subject:	RE: re[2]: MYSQL Date Format
From:	Tim Endres (ti...@trustice.com)
Date:	03/19/2003 11:11:54 AM
List:	com.mysql.lists.win32

The best date format for programers is YYYYMMDD, because this format sorts perfectly as an integer, a very useful quality. Otherwise, I agree that the British format (DDMMYYYY) is more logical than the American (MMDDYYYY).

tim.

<FILTER> MYSQL DATABASE </FILTER>

Just saw your email...

Just a small point.

Our schools have not taught what we call "Imperial" measurements for over 15 years (I was never taught them).

We are metric too.... Which means... America is the only one using our old (British) system, which is difficult and very confusing.

SI units (a subset of metric) are the way ahead.

I agree totally on the date format. The British DDMMYYYY format and the American MMDDYYYY are just plain mad, well actually, the british format isn't too bad! ;-)

I stand corrected. (I knew the English were smarter!)

At least the british date format has some sort of sequence to it. The U.S. one is just crazy.

Having grown up in American and having to learn the crazy measurement systems we use, I think we are totally backwards here. The Metric system is sooooo logical. Base 10, no fractions, etc. How much easier is it to figure out what 3 x 0.5 versus 3 X 1/2? 10cm is a much easier measurement to figure out than 3/8 of an inch. Hell, it's even a pain with cooking, we use Tablespoons and Cups and such. Ounces versus grams?