How to use jQuery dataTable to sort dateTime format 01-JAN-2016 10:00
<p>I code for a search result table, and I get the <code>startDate</code>, <code>startTime</code>, <code>endDate</code>, and <code>endTime</code> from <em>oracle database</em>; and use ajax to show the data in front-end, we use Firefox for all of the development and test. </p>

<p>I need to sort based on the <code>startDate</code> and <code>startTime</code> (some data does not have <code>startTime</code>), also <code>endDate</code> and <code>endTime</code> (some data does not have <code>endTime</code>) when I click the sort icon. I use <strong>moment.js</strong>, but failed. Could you help me. this is my js side code.</p>

<pre><code>searchRequest =
    $.ajax({
        type: 'POST',
        url: G_REL_URL + '/getData',
        data: inputs,
        async: true,
        error: function (objAJAXRequest, strError) {
            try {
                console.log('AJAX error: ' + strError);
            } catch (e) {
            }
        },
        dataType: 'HTML',
        complete: function (response, status) {
        },
        success: function (data) {

            $('#div_search_bottom_srch').html(data).show();
            $.fn.dataTable.moment('DD-MMM-YYYY HH:mm');
            $('#search_results_table').dataTable({
                "aaSorting": [],
                "sScrollY": "400px",
                "asStripeClasses": [],
                "bFilter": false,
                "bPaginate": false,
                "scrollX": false,
                "autoWidth": false,
                "aoColumnDefs": [
                    { "type": "datetime-moment", targets: [3, 4] },
                    { "bSortable": false, "aTargets": [0, 6, 7, 8, 9] }
                ]

            });
</code></pre>

<p>It seems it only sort based the date, and ignore month and year.</p>