Skip to Content Skip to Menu

CB Query Field - Language Output of Date

6 years 8 months ago #302561 by giorgionasis
CB Query Field - Language Output of Date was created by giorgionasis
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>&nbsp&nbsp&nbsp&nbsp<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

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48541
  • Thanks: 8290
  • Karma: 1445
6 years 8 months ago #302617 by krileon
Replied by krileon on topic CB Query Field - Language Output of Date
You can't as that comes from SQL directly. See the below MYSQL documentation regarding SQL language.

dev.mysql.com/doc/refman/5.6/en/locale-support.html


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum