As for y/m/d, I completely agree, but for a full sort, we should also write hh:mm:ss !
Dave Sent from my iPad On Nov 13, 2013, at 1:43 PM, Thaddeus Weakley <thadweak...@yahoo.com> wrote: > I too strongly agree with Paul. The YYYY/MM/DD format sorts numerically; > something that I gravitated to when a lad with database set-up and > administration. > > This format also seems the most logical to me. In the grand scope of things, > the millenium, century, year, month, day typically take precedence in that > order. > > And now that we increasingly are interacting with a global market - a > consistant, logical, and readily understood data format seems as important as > ever.... > > Thad Weakley > American expat in Montreal, Quebec > > >> ---- Sunclocks North America <sunclock...@icloud.com> > wrote: >> >> ============= >> This has always been a pet peeve of mine! >> All of these differing date formats are confusing, as > you can never really be sure >> which one people are using. Here in Canada, it's > even worse because some people put >> the month first like in the USA and others put the day > first and yet others put the >> year first! Nobody can be sure if something like > 10/11/12 means October 11th 2012, >> November 10th 2012 or November 12th 2010! At > least now that we're in 2013, some of >> that confusion is gone for the next 87 years. >> I think that the best way which everyone in the world > understands is to start a four >> digit year: yyyy/mm/dd, and all the confusion goes away > with the simple addition of two >> characters. Plus the dates can be easily sorted > numerically. It's pretty much the >> only date format I ever use unless I spell out the > month. >> >> Paul Ratto >> SunClocks North America >> >> >> --------------------------------------------------- >> https://lists.uni-koeln.de/mailman/listinfo/sundial >> > > -- > ------------------------ > Peter Mayer > Discipline of Politics & International Studies (POLIS) > School of History & Politics > http://www.arts.adelaide.edu.au/historypolitics/ > The University of Adelaide, AUSTRALIA 5005 > Ph : +61 8 8313 5609 > Fax : +61 8 8313 3443 > e-mail: peter.ma...@adelaide.edu.au > CRICOS Provider Number 00123M > ----------------------------------------------------------- > > This email message is intended only for the addressee(s) and > contains > information that may be confidential and/or copyright. If > you are not > the intended recipient please notify the sender by reply > email and > immediately delete this email. Use, disclosure or > reproduction of this > email by anyone other than the intended recipient(s) is > strictly > prohibited. No representation is made that this email or any > attachments > are free of viruses. Virus scanning is recommended and is > the > responsibility of the recipient. > --------------------------------------------------- > https://lists.uni-koeln.de/mailman/listinfo/sundial > > > --------------------------------------------------- > https://lists.uni-koeln.de/mailman/listinfo/sundial > --------------------------------------------------- https://lists.uni-koeln.de/mailman/listinfo/sundial