Auto date detection doesn't work in IE

bontha786

I have a dataTable with one column that contains the date values fetched from oracle db in format : DD-MON-YYYY HH24:Mi:SS (SQL format)

SORTING WORKS WELL IN CHROME but not in IE. Any suggestions please.

Ascending Order in IE which is not in order
--------------------------------

04-MAR-2013 07:12:08
10-JUL-2013 22:32:48
11-AUG-2012 00:18:12
12-NOV-2012 09:21:26
15-OCT-2013 09:56:09

Descending Order in IE which is also not in order
-----------------------------------

15-OCT-2013 09:56:09
12-NOV-2012 09:21:26
11-AUG-2012 00:18:12
10-JUL-2013 22:32:48
04-MAR-2013 07:12:08

Code from page
------------------

jQuery(document).ready(function(){

jQuery('.dataTable').dataTable({"bPaginate": false, "bFilter": false, "bInfo": false,"bRetrieve": true,"bDestroy":true});

});

Regards
Babu

allan

Only dates formatted YYYY-MM-DD will work across all browsers since DataTables uses Javascript's `Date.parse()` method and the Javascript spec doesn't specify what date formats should be detected.

You need to use a sorting plug-in: http://datatables.net/development/sorting

Allan