1

I have a Windows MySQL server running (5.6), and in the my.ini file I have the following directive under [mysqld]:

lc_time_names = 'fr_FR';

But it has ZERO effect. When I start up the server, all time names are still in English. If I then launch Workbench and issue the following command:

SET GLOBAL lc_time_names = 'fr_FR';

it works and the times are changed. Is there something different I need to do in my.ini?

UPDATE (VERY IMPORTANT): in addition to needing to put this value in the correct ini file, you also need to NOT ADD QUOTES!! I broke my server with the above, and it took me forever to figure out I needed to change the line to

lc_time_names = fr_FR

WITHOUT THE QUOTES, or your MySQL server will not start up! Hope this helps someone else.

Stephen
  • 111
  • 1
  • 3

1 Answers1

0

You could simply pass the third parameter as a local value. ^^

SELECT DATE_FORMAT("2023-06-15", '%W %d %M %Y','it_IT') as date;

output: giovedì 15 giugno 2023

SELECT DATE_FORMAT("2023-06-15", '%W %d %M %Y','fr_FR') as date;

output : jeudi 15 juin 2023

SELECT DATE_FORMAT("2023-06-15", '%W %d %M %Y','ja_JP') as date;

output : 木曜日 15 6月 2023

for more information, here MySQL Server Locale Support

Imen A.
  • 121
  • 4