Day and month language names dataset

Hello,

I’m trying to get a day and month name from a dataset date in an other language.

In mysql (ubuntu 16.04 terminal) I’ve set the lc_time_names.
In the cms I set the locale to another language.

But DATE_FORMAT(Date,’%a’) keeps returning the English name of the day.

Hope somebody can help.

Thanks.

Bert

We’d expect that to work and I believe it did work in the past with the lc_time_names changed - I’ve created an issue about it, we will investigate it further and perhaps make those changes a bit easier and user friendly (ie without the need to make direct database changes).

Hello Peter,

Thanks.

After setting the lc_time_names on the command line, getting a week day with a command line instruction results in a day in the correct language. Is there a change that xibo is resetting the language?

grtz

I have a tempory work around, not the most elegant one, but it works.

In PdoStorageService.php add a line in the SetTimeZone() member;
$this->getConnection($connection)->query(‘SET lc_time_names = ‘’;’);