Hallo there,
I use CB Query Field and I would like to to know how I can change the output language of a date.
My Query is 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 I display it like this:
<span style="font-weight:normal;">[column_title]</span>    <span>[column_GEORGE]</span>
But the output of the month is in English as concern the months
However i use my language (Greek) as Default Language.
How can i change it?
Thank you