The lc_time_names server system variable sets the language used by the date and time functions DAYNAME(), MONTHNAME() and DATE_FORMAT().

The list of the locales supported by the current MariaDB installation can be obtained via the LOCALES plugin, available since MariaDB 10.0.4.

MariaDB supports the following locale values:

Examples

Setting the lc_time_names and lc_messages variables to localize the units of date and time, and the server error messages.

SELECT DAYNAME('2013-04-01'), MONTHNAME('2013-04-01');
+-----------------------+-------------------------+
| DAYNAME('2013-04-01') | MONTHNAME('2013-04-01') |
+-----------------------+-------------------------+
| Monday                | April                   |
+-----------------------+-------------------------+

SET lc_time_names = 'fr_CA';

SELECT DAYNAME('2013-04-01'), MONTHNAME('2013-04-01');
+-----------------------+-------------------------+
| DAYNAME('2013-04-01') | MONTHNAME('2013-04-01') |
+-----------------------+-------------------------+
| lundi                 | avril                   |
+-----------------------+-------------------------+

SELECT blah;
ERROR 1054 (42S22): Unknown column 'blah' in 'field' list'

SET lc_messages = 'nl_NL';

SELECT blah;
ERROR 1054 (42S22): Onbekende kolom 'blah' in field list