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 <[email protected]>
> 
>> 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
>> [email protected]
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
> _______________________________________________
> use-revolution mailing list
> [email protected]
> 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.

_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to