Dates should be persisted as intervals since epoch where the interval is the finest grain required. This is what enables more sophisticated tools to do sorting and change representations.
But this is a conversation about text formatting of dates. The standards for this are well established. Yes, padding is required and assumed.
Humans think day/month or month/day, they have absolutely no interest in reading the year first.
Humans prefer what is familiar. Speaking as a human, for me that’s ISO 8601.
Comments
lexicographically sorting is of lower interest to me than the other advantages. yours would also require padding numbers with leading zeroes.
If you need sorting, use a tool that understands dates, simple as that. Many tools do, just some common businesss microsoft tools don't.
Humans think day/month or month/day, they have absolutely no interest in reading the year first.
Dates should be persisted as intervals since epoch where the interval is the finest grain required. This is what enables more sophisticated tools to do sorting and change representations.
But this is a conversation about text formatting of dates. The standards for this are well established. Yes, padding is required and assumed.
Humans prefer what is familiar. Speaking as a human, for me that’s ISO 8601.