Click here to Skip to main content
15,890,282 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB25-May-16 8:04
W Balboos, GHB25-May-16 8:04 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
kalberts26-May-16 0:49
kalberts26-May-16 0:49 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 1:08
W Balboos, GHB26-May-16 1:08 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
kalberts26-May-16 1:20
kalberts26-May-16 1:20 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 1:30
W Balboos, GHB26-May-16 1:30 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
kalberts26-May-16 1:49
kalberts26-May-16 1:49 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 2:02
W Balboos, GHB26-May-16 2:02 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
kalberts26-May-16 3:20
kalberts26-May-16 3:20 
W∴ Balboos wrote:
First, the hypen and slash delimited versions of YYYYMMDD still sort trivially as text.
Sure - as long as everybody uses the same separator. But not everyone does.

Finding a truly trivial sorting problem is not a trivial task... Smile | :) Especially not in multi-national environments. You believe that alphabetic sorting is trivial? What about a common Scandianvian telephone book with Norwegian and Swedish names? The Norwegian alphabet goes ...wxyzæøå, while the Swedish goes ...wxyzåäö - the ä and æ are (from both sides) considered the same letter, as is ö and ø. So where should å be sorted: Before æø or after æø?

Or French, where you sort by the alphabetic character as the primary key, but two words differ in accents (which quite often is the case in French), they are not identical, and the sort order of the accents, as a secondary key, is well defined. Or Spanish, where certain double letters are sorted as a single letter, but not in an identical manner: I believe (disclaimer: I cannot speak Spanish myself) that ll is one case: The double ll is sorted as a if it were a single letter between l and m in the alphabet.

These details does not relate to your highly "synthetic" format that is not acceptable for use by common man. It is nothing but a lab prototype. That is what I wanted to stress as "the real point".

We could simplify sorting of dates by using the day number of the year - abandoning months and day within month completely: Problem solved!

Or we could use Unix epoch: Geek & Poke, 20081221[^]
(For those who have not yet discovered Geek & Poke: That is the greatest source of computer geek humour I have ever seen!)

Obviously, a list of eight digit decimal numbers can be trivially sorted. But is is about as useless as sorting a ten digit number such as 1229883309. Well, not quite, but if people won't accept that eight digit decimal number, then it is of no help that it will trivially sort.
GeneralRe: Only American and Swahili use mm/dd for dates Pin
gervacleto26-May-16 2:18
professionalgervacleto26-May-16 2:18 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 2:46
W Balboos, GHB26-May-16 2:46 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Michael Waters26-May-16 3:53
Michael Waters26-May-16 3:53 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Steven121826-May-16 6:42
professionalSteven121826-May-16 6:42 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Michael Waters26-May-16 7:00
Michael Waters26-May-16 7:00 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Michael Waters26-May-16 7:29
Michael Waters26-May-16 7:29 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Benito Aramando26-May-16 2:59
Benito Aramando26-May-16 2:59 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 3:14
W Balboos, GHB26-May-16 3:14 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Benito Aramando26-May-16 3:36
Benito Aramando26-May-16 3:36 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB26-May-16 3:50
W Balboos, GHB26-May-16 3:50 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Benito Aramando26-May-16 4:02
Benito Aramando26-May-16 4:02 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
OriginalGriff25-May-16 8:07
mveOriginalGriff25-May-16 8:07 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
W Balboos, GHB25-May-16 8:13
W Balboos, GHB25-May-16 8:13 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Mark_Wallace25-May-16 8:40
Mark_Wallace25-May-16 8:40 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
jgakenhe25-May-16 10:37
professionaljgakenhe25-May-16 10:37 
GeneralRe: Only American and Swahili use mm/dd for dates Pin
Marc Clifton25-May-16 12:50
mvaMarc Clifton25-May-16 12:50 
JokeRe: Only American and Swahili use mm/dd for dates Pin
Paulo_JCG25-May-16 22:04
professionalPaulo_JCG25-May-16 22:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.