Creating trigger to manipulate language
Here is a way to get the name of the month in French, then you can use CONCAT to construct the date however you want:

SET @month=month("23/05/2016");
SELECT CASE @month 
    WHEN 1 THEN "janvier"
    WHEN 2 THEN "février"
    WHEN 3 THEN "mars"
    WHEN 4 THEN "avril"
    WHEN 5 THEN "mai"
    WHEN 6 THEN "juin"
    WHEN 7 THEN "juillet"
    WHEN 8 THEN "août"
    WHEN 9 THEN "septembre"
    WHEN 10 THEN "octobre"
    WHEN 11 THEN "novembre"
    WHEN 12 THEN "décembre"
END INTO @nom_de_mois;
SELECT @nom_de_mois;


Working example:

mysql&gt; SET @month=month("2016-05-23");
Query OK, 0 rows affected (0.00 sec)

mysql&gt; SELECT CASE @month 
    -&gt;     WHEN 1 THEN "janvier"
    -&gt;     WHEN 2 THEN "février"
    -&gt;     WHEN 3 THEN "mars"
    -&gt;     WHEN 4 THEN "avril"
    -&gt;     WHEN 5 THEN "mai"
    -&gt;     WHEN 6 THEN "juin"
    -&gt;     WHEN 7 THEN "juillet"
    -&gt;     WHEN 8 THEN "août"
    -&gt;     WHEN 9 THEN "septembre"
    -&gt;     WHEN 10 THEN "octobre"
    -&gt;     WHEN 11 THEN "novembre"
    -&gt;     WHEN 12 THEN "décembre"
    -&gt; END INTO @nom_de_mois;
Query OK, 1 row affected (0.00 sec)

mysql&gt; SELECT @nom_de_mois;
+--------------+
| @nom_de_mois |
+--------------+
| mai          |
+--------------+
1 row in set (0.00 sec)

mysql&gt; SELECT CONCAT(date_format("2016-05-23", "%d"), " ", @nom_de_mois, " ", date_format("2016-05-23", "%Y")) AS date_in_French;
+----------------+
| date_in_French |
+----------------+
| 23 mai 2016    |
+----------------+
1 row in set (0.00 sec)