Local language output for Dayname and date_format

[Emanuele Dolis]

Hello everyone,
I've looked for this silly matter around both the documentation and the forums, but I've found no answer.
The question is:
how can I configure mysql so that the literal format of date_format (%M, %a, %b etc.) and similar functions give an output in a local language? (eg "Gennaio" instead of "January").
I know, of course that a CASE with the numeric value matching the appropriate string could do, but I think there must be a direct and efficient way to do it using the mysql appropriate functions.
Any suggestion?

Thanks a lot
Emanuele