Datatables Datetime Sorting Without Days Zero

ByBerk

Hi,

I have a problem for the datetime sorting without days front zero. This is interesting problem.
For Example date
31.08.2019
20.08.2019
3.09.2019
2.09.2019
and sorting
2.09.2019
20.08.2019
3.09.2019
31.09.2019

I think if substring(dd-mm-yyyy) datetime from sql maybe solve. But another solution?

Thanks

kthorngren

See if this blog about datetime sorting helps.

Kevin