Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Formatting Dates with 3 Character Months (SQL Spackle) RE: Formatting Dates with 3 Character Months (SQL Spackle)

  • January 20, 2011 at 4:16 am

    #1275780

    David McKinney (1/20/2011)

    Très bien, Jeff! Except of course that you can't keep everybody happy!

    In France, June and July are Juin and Juillet respectively, and hence JUI and JUI when truncated to 3 characters.

    It gets even worse for languages such as Finnish, Estonian, & Czech (to name but a few).

    For instance Czech uses the Roman numerals (I,II,III,IV etc.) for short month names, and in Estonian the short month names vary in length from 3 to 5 characters.

    Nigel
    How to post questions