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 1:14 am

    #1275721

    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.

    Some would say I'm just being pedantic - and they would be right - but it's more important to me, who lives in France, than to most of you who don't 😉

    I'd maybe consider a translations table?

    I knew there'd be at least one fly in the ointment. Considering those two months are so closely named, do you ever use 3 character months? If so, then I agree... a translation table may be better for the French language. Thanks for the feedback, David. I appreciate it.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)