Date and time locales available in MariaDB

The following table is a complete list of date and time locales available in MariaDB.

You can set lc_time_names to any of the above to change the current locale.

The following statement modifies the current locale to zh_HK:

SET lc_time_names = 'zh_HK';

The following statement returns the current locale:

SELECT @@lc_time_names;

Modifying the current locale will affect the output of the DAYNAME(), MONTHNAME(), and DATE_FORMAT() functions.

You can also use the SHOW LOCALES command to display all the locales in MariaDB.