Date Sorting issue: saved db field as YYYY-MM-DD; need table display and sort as DD-MM-YYYY

alzambo

Hi,
I have a mysql date field that is saved, for example, as 2015-06-26 and I need to display and sort it in a datatable as 26-06-2015.

I think that "it's not rocket science" but I've read a bunch of articles without understand where I should start from (server-side, some plugin or not, moment, etc).

This is my debug code: aninog and, if needed, i will post my code.
Alex

tangerine

Either (back end) use MySQL's DATE_FORMAT function when retrieving data,
or (front end) use DataTables' "render" function to reformat the data for display.

alzambo

Yeah!
So simple... thank you!