Thread: Format of date
View Single Post
05/29/14, 03:11 AM   #5
Vuelhering
AddOn Author - Click to view addons
Join Date: Mar 2014
Posts: 169
Originally Posted by olleg View Post
Later was arised compromise known as ISO
YYYY-MM-DD

Never undestand programmers who mixing this format in complex style.
The YYYYMMDD format allows simpler comparisons where larger numbers are always later than smaller numbers. Thus, 20131201 (dec 01, 2013) is always greater than 20101031 (oct 31, 2010). But in other systems, 31102010 > 01122013 but 12012013 > 10312010. It also follows that the least significant digits are the least significant (days, instead of years).

This type of representation is the very basis of our place value number system, even though it uses place values that are not base-10 (containing digits that are base 10!). It is unambiguous and universal, and most importantly, consistent when comparing dates.

If you want strange, look at timezones across the world, and if you figure that out, add in DST.

Last edited by Vuelhering : 05/29/14 at 03:23 AM.
  Reply With Quote