hallo there!

i use a query to extract the publish_up column of the item.

i successfully do that in the query like DATE_FORMAT(publish_up, "%d %M %y") AS 'GEORGE' and then display the column.

But the output for the month is in English and no in my language. I have checked everything in translation files but with no success. Am i missing something?
In the site every other translation works fine.

thank you very much

Where are you trying to display this date? K2 content module, component etc?

hallo Krikor!

i am trying to display it in Community Builder!Everything there is also translated in my language. I read somewhere that it takes the php variables and cannot be affected. is it true?

thank you!

This post will help you docs.joomla.org/JFactory/getDate

hallo krikor!

i read it but i cannot understand how this can help..
i am able to retrieve the date, and the date is right. The only problem is that it is not displayed in my language but in English.

thank you

You can try passing, the date as a variable in the JDate function.

EG: