
Date and time formats
January 28, 2008Did you know there’s an international standard for date and time formats? It eliminates the confusion that arises when dates in one format are viewed by people in another country who use a different format. For example, to me (in Australia), 4/5/2008 is the 4th of May, 2008, but to someone in the US, this is the 5th of April, 2008—quite a different date.
In essence, the standard says to write dates and times from largest to smallest, so yyyy-mmm-dd for dates and hh:mm:ss for time.
The standard is ISO 8601 and you can find out more about it here:
- http://en.wikipedia.org/wiki/ISO_8601 (Wikipedia entry)
- http://www.w3.org/QA/Tips/iso-date (W3C tips for webmasters)
- Purchase the standard from the ISO.org
- http://www.cl.cam.ac.uk/~mgk25/iso-time.html (summary of the international date and time formats)
In the December 2002 CyberText Newsletter, I also wrote about this standard for date formats. Here’s some additional information from that article:
For ease of use in sorting, filing and retrieving computer documents, [using this date format] is a preferred method. It is also simpler for calculating elapsed time, and combines naturally with the big-to-small convention used for hh mm ss when you need to be more specific about a date/time.
Because we should be writing in such a way that we don’t exclude parts of our audience, we should be using a date convention that is globally acceptable—we don’t have to say our dates this way, but we should be using this format in our professional communications, such as letters, faxes, and the like.
See also:
![]() |
Has this tip helped you? saved you time? saved your skin? You can thank me by clicking on the cup and buying me a coffee. (An E-Junkie shopping cart page will open where you can pay for my coffee via PayPal.) |




Hi Rhonda, I finally read this post you referenced in your message to the STCCIC mailing list. I remember reading about yyyy-mm-dd being an international standard several years ago, but I had already standardized on that format for myself several years before that.
This format, with or without dashes, in addition to being explicitly clear in its meaning, is very effective for naming folders, files, and even my invoices so that they sort chronologically.
Thanks for all that you do!
Rhonda,
Since 2010 Jan 1 I have been using the following number formats to sequence files produced each day.
filename0101.ext
..january
filename0131.ext
filename0201.ext
..february
filename0207.ext
This system is good for a year.
For one that will be good for 10 years
filename00101.ext
..etc.
..Bruce White..
@winhelp3
[...] ISO date and time formats: http://cybertext.wordpress.com/2008/01/28/date-and-time-formats/ [...]