mysql date format regarding to a specific country

Question

I used MySQL function DATE_FORMAT(table.field, '%d %b %Y'), where the first parameter is my column, and the second is a pattern to format the column according to a date logic.

The output of this function is in english :

10 Feb 2014

And I would like to set the locale language to fr_FR which would output this correct string :

10 Fév 2014

Question : How to change locale language of the DataBase right before the query (in order to change it according to another language) ?

Answer 1

you need to set the correct language setting in the MySQL Server. Look here: MySQL DATE_FORMAT() function

The language used for day and month names and abbreviations is controlled by the value of the lc_time_names system variable (Section 10.7, “MySQL Server Locale Support”).

Run this before your query:

SET lc_time_names = 'fr_FR';

Then set it back to the original value of lc_time_names;