?

Log in

No account? Create an account
Paul's Page
Dating, but not that type 
30th-Mar-2008 08:33 am
brain
Date formats in Canada confuse me, and judging by the article in ComputerWorld that I was just reading, I'm not alone. Apparently the writer looked at "over 50 documents from 40 different organizations, only about 25 per cent had printed dates that were completely unambiguous". Worse than that, some organisations (e.g. Canadian Tire, RBC Royal Bank) "use different [date] formats on different documents"!

Poll #1162895 Date formats

Which date format(s) do you use? (dd=day, mm=month number, MMM=month name, yy=year, ccyy=century+year) (Ignore whether the separator is / or - or something else for now)

dd/mm/yy
0(0.0%)
dd/mm/ccyy
0(0.0%)
mm/dd/yy
1(12.5%)
mm/dd/ccyy
0(0.0%)
yy/mm/dd
1(12.5%)
ccyy/mm/dd
1(12.5%)
yy/dd/mm
0(0.0%)
ccyy/dd/mm
0(0.0%)
dd/MMM/yy
0(0.0%)
dd/MMM/ccyy
1(12.5%)
something else (tell me more in the comments)
0(0.0%)

Where do you live? (I think the UK and USA have de facto standard formats - it's Canada that I think is indecisive, but let's see)

Canada
7(87.5%)
UK
1(12.5%)
USA
0(0.0%)
Europe
0(0.0%)
other
0(0.0%)

Do you think it would be clearer if everyone adopted a single format of dd-MMM-yyyy, for example 30-MAR-2008 ?

yes
6(75.0%)
no (tell me why in the comments)
2(25.0%)
Comments 
30th-Mar-2008 01:01 pm (UTC)
I forgot one: I tend to use yymmdd for my own notes, but then I'm a geek :)
30th-Mar-2008 01:09 pm (UTC)
...And don't get me started about the (lack of) adoption of week numbers here. I use them all the time but it tends to result in blank looks from most of my colleagues.
30th-Mar-2008 01:06 pm (UTC) - Before anyone points it out
I know there is a standard for date/time formats (ISO 8601) but I doubt that many people are aware of it and even fewer actually follow it. Basically it says to use ccyy-mm-dd, which I think make sense.
30th-Mar-2008 01:07 pm (UTC) - Re: Before anyone points it out
Oh, and Canada has signed up to use ISO 8601 but clearly that's not the reality.
30th-Mar-2008 02:55 pm (UTC) - Re: Before anyone points it out
I'd be one of those ones who does use the ISO date standard.
31st-Mar-2008 02:25 am (UTC) - Re: Before anyone points it out
Out of choice or because of your job?
31st-Mar-2008 10:55 pm (UTC) - Re: Before anyone points it out
Choice. It's the only one that makes logical sense to me, and seems to be the one that's the least ambiguous. I try pretty hard to get everyone at work to adopt it too...
30th-Mar-2008 07:46 pm (UTC)
Canada that I think is indecisive

Canada has a Std, and it's YYYY-MM-DD I believe. (i'm trying to search as we speak to get the asnwer)

the problem is that we are heavily influenced by the US which uses MM-DD-YYYY
30th-Mar-2008 07:49 pm (UTC)
Annnnnnnnnnnd I found it.

8. Is there a standard for documenting date and time?

Canadian Standard CAN Z234-4 specifies numeric representations of date and time. The recommended full format is of the form 2001-12-31 23:59:28.73 UTC. It is compatible with International Standard ISO 8601. This standard notation helps to avoid confusion in international communication caused by the many different national notations. In addition, these formats have several important advantages for computer usage compared to other traditional date and time notations. The time notation described in ISO 8601 is already the de-facto standard in almost all countries and the date notation is becoming increasingly popular.

References:

* A Summary of the International Standard Date Time Notation, and Date/Time Representations, ISO 8601
* CAN Z234-4 can be obtained through Standards Council of Canada (SCC), and ISO 8601 from International Organization for Standardization (ISO).


http://inms-ienm.nrc-cnrc.gc.ca/faq_time_e.html#8


(and in case you didn't know, The Gov't runs an NTP server that sync's with one of the Cesium Atomic Clocks -- The same one(s) you hear on CBC everyday -- http://inms-ienm.nrc-cnrc.gc.ca/time_services/network_time_protocol_e.html )

30th-Mar-2008 08:21 pm (UTC)
I mentioned ISO 8601 above but how many really adhere to it? Does the government even use it consistently?
31st-Mar-2008 01:16 am (UTC)
Does the government even use it consistently?

In official communications, AFAIK ... Yes (ie: the bottom of the Jobs webpage has the date in YYYY-MM-DD http://jobs-emplois.gc.ca/menu/home_e.htm )

Internally however (like if I'm making a powerpoint presentation, or a report for my boss), it's a mish-mash of dates
This page was loaded Nov 21st 2017, 10:44 pm GMT.