Datatables Sorting Time Column

I'm using jQuery DataTables and I have a problem when I'm sorting my time column with this format mm:ss. For example when I sort this 00:08 the sort does something but this is not

Solution 1:

You have to use Sorting plug-ins.

It allows you to sort the columns based on type and not only on data.

Your code will be like this:

<scripttype="text/javascript"src="jquery.dataTables.js"></script><scripttype="text/javascript"src="dataTables.numericComma.js"></script><scripttype="text/javascript">
    $(document).ready(function() {
        $('#example').dataTable( {
            "columnDefs": [
                { "type": "time", targets: 3 }
            ]
        } );
    } );
</script>

Solution 2:

I had the same issue today and found the solution. Here is the code.

<scripttype="text/javascript"src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script><scripttype="text/javascript"src="//cdn.datatables.net/plug-ins/1.10.19/sorting/time.js"></script><scripttype="text/javascript">
        $(document).ready(function() {
            $('#example').dataTable( {
                columnDefs: [
                         { type: 'time-uni', targets: 7 }
                    ]
            } );
        } );
    </script>

You can also check other sorting plugins here: https://cdn.datatables.net/plug-ins/1.10.19/sorting/