I'm using DataTables.js to render my tables, the problem is that the date displayed in the table is already converted to d / m / Y and if I click reorder by column it will not display the data correctly, you can sort in ascending / descending order by this type of field, only with Y / m / d would you reorder it, would you have any solution to this problem?
PS: The easiest way I found was to display the MySql default date in Y / m / d format, but reading to the user is very complicated and at the time of exporting it exports what is on the screen.