Sortable Dateformat

YYYY/DD/MM or YYYY/MM/DD ?

It's simple:

An important exploitation of lexicographical ordering is expressed in the ISO 8601 date formatting scheme, which expresses a date as YYYY-MM-DD. This date ordering lends itself to straightforward computerized sorting of dates such that the sorting algorithm does not need to treat the numeric parts of the date string any differently from a string of non-numeric characters, and the dates will be sorted into chronological order. Note, however, that for this to work, there must always be four digits for the year, two for the month, and two for the day, so for example single-digit days must be padded with a zero yielding '01', '02', … , '09'.

http://en.wikipedia.org/wiki/Lexicographic_order

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License