Date, time and other formats for many many languages !
By pierrot on Aug 24, 2009
Which is the format German use for dates ? dd MMMM ? No I meant the long date format for Spanish.... And what about the French one !? And are the month name starting with an uppercase letter in Spanish ?
All those little questions can quickly become problematic to answer since there are always some little differences between the languages.
I found this page very helpful: http://www.sql-und-xml.de/server-daten/culture-info/
It is in German, but even for non-German speakers it is quite east to understand. The list of languages is really complete, and there is a lot of information. On little minus, not always the same info is shown for different languages... But that's only a little drawback comparing to how helpful it can be !!!
So to our answer our questions:
- German format for dates: dd.MM.yyyy
- Spanish format for long dates: dddd, dd' de 'MMMM' de 'yyyy
- French format for long dates: dddd d MMMM yyyy
- Spanish month names: lowercase (enero, febrero, marzo, abril, mayo, junio, julio, agosto, septiembre, octubre, noviembre, diciembre)
Easy hum ? :)