I make a query directly on the database like this:
SELECT title,id, DATE_FORMAT(publish_up, "%d %M %Y") AS 'GEORGE' FROM #__k2_items WHERE published=1 AND trash=0 AND created_by=[id] ORDER BY publish_up DESC;
and then display it like that:
<span style="font-weight:normal;">[column_title]</span>    <span>[column_GEORGE]</span>
The output is in English but I want it in my language.
This query is done within Community Builder with the help of a plugin.
I have search all the files and I have changed for example "January" with my countries word but with no result.
Is it a localize thing of mysql database?How can I fix that?