Need help with displaying UK date format
Need help with displaying UK date format
genov80
Posts: 5Questions: 2Answers: 0
Hi guys,
I am trying to display UK (d/m/Y) time format in the data table but have no idea how to do it. Tried to find it out myself but I just gave up. My programming skills are not as good as I wished so any help explained like to a clueless will be greatly appreciated.
Thanks!
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
What is your data source, and what is its date format?
Hi, the data source is a mysql db. I'm using server side processing.
Use MySQL date formatting function in your db query.
Thanks for the advise but now I hit another wall.
Because of UK date format sorting problem I'm getting an error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'DATE_FORMAT(date,'%d/%m/%Y') AS date_converted' in 'field list'