C
Chris Croughton
Not always.
string("31/12/2004 23:59") > string("01/01/2005 00:00") (lexicographically)
If the year is the same in both, what you say is true.
No, only if both the year and the month are the same.
string("31/01/2004 23:59") > string("01/02/2004 00:00") (lexicographically)
That's why ISO 8601 is better, because everything proceeds left to right
as the significance is less, just as in numeric formats (excluding
things like Roman numerals!):
string("2004-01-31 23:59") < string("2004-02-01 00:00") (lexicographically)
which is correct for all values of date.
Chris C