All Questions
Tagged with community-builder database
1 question
1
vote
2
answers
181
views
Localize output of SQL query
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 ...
- 173