|
The universal date format is YYYY-MM-DD with preceding zeroes in the month and day.
In that format, it's always largest to smallest granularity. The hour:minute:second works with it as well, and the date value always sorts correctly.
However, there is this little Y10K problem that will crop up and kill us all.
|