Date formats around the world especially Canada

[Bill Vlahos]

Thanks for all the suggestions.

However, I've noticed something disturbing. Windows XP does not have a "Canada" setting. It has an English (Canada) and French (Canada). Neither of which matches the Mac "Canada" setting. WTF?

What do the Canadian Windows users have for their short date setting? Does it match the Mac short date settings below?

Bill Vlahos

On Nov 28, 2009, at 2:54 PM, stephen barncard wrote:

> To ensure compatibility among platforms and countries;
> use the seconds as the stored time data, then convert on the fly at
> showtime. The dates and times should "just work" and formatted as they are
> set by the user. You shouldn't have to do any fancy conversions.
> 
> sqb
> -------------------------
> Stephen Barncard
> San Francisco
> http://houseofcubes.com/disco.irev
> 
> 
> 2009/11/28 Bill Vlahos <bvlahos at mac.com>
> 
>> How do folks deal with storing dates when the formats around the world vary
>> so much?
>> 
>> Table below is for different countries according to Mac OS 10.6.2
>> 
>> Australia       05/01/2009      5/01/09
>> Canada  2009-01-05      09-01-05
>> Hong Kong       5 Jan 2009      05/01/2009
>> India   05-Jan-2009     05/01/09
>> Jamaica Jan 5, 2009     1/5/09
>> South Africa    05 Jan 2009     2009/01/05
>> United States   Jan 5, 2009     1/5/09
>> 
>> A date string in one country isn't a date in a different country. How do
>> you make them consistent if the user changes the formatting options?
>> 
>> Bill Vlahos
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

Bill Vlahos
_________________
InfoWallet (http://www.infowallet.com) helps me remember the important details of my life.