ZTree.com  | ZEN  | About...  

 Index   Back

[Q] date formats and omission of leading zero   [Zeta]

By: Laurent Duchastel     Montréal, Québec  
Date: Nov 06,2017 at 17:24
In Response to: [Q] date formats and omission of leading zero (Hartmut Schneider)

> Just stumbled over the CO-1K date formats when the day-of-month is
> between 1 and 9.
>
> While date formats starting with month are familiar to me
> as 9-11-2017 or size="3" color="#003399"> 9-11-17 ,
> I feel unfamiliar with leading zero for the date formats starting with
> the day
> - dd-mm-yy, e.g. 1-12-17
> or
> - dd-mm-yyyy,    
> 1-12-2017
>
> Is this usual all over the world?
>
> If not, would it be more suitable if days 1..9 always have a
> leading zero?

In Canada, the official recommendation, and the one I use, is YYYY-MM-YY, with leading zero everywhere.

https://en.wikipedia.org/wiki/Date_and_time_notation_in_Canada
Actually, this recommendation is ISO 8601.

In practice, we have a mix environment here because of technology used and bilingual environment (English or French). A significant number of firms, technological devices and software from the US (which is a significant part of firms, tech devices and software overall in Canada) do not have all the provisions to adapt to official Canadian standards.

We end with bills, documents, and machines having either MM/DD/YY, DD/MM/YY, YY/MM/DD and YYYY/MM/DD as date standard. An accounting **nightmare**. Was that bill issued March 7, 2011. or July 3, 2011 or July 11, 2003 ???

YYYY-MM-DD is none-ambiguous.
Same with 00:00 along 24 hours format.


Laurent Duchastel

1,173 views      
Thread locked
 

Messages in this Thread

 
96,637 Postings in 12,231 Threads, 350 registered users, 74 users online (0 registered, 74 guests)
Index | Admin contact |   Forum Time: Mar 28, 2024 - 9:36 am UTC  |  Hits:62,361,689  (14,086 Today )
RSS Feed