Datatable timestamp wrong format

Question

2019-11-19 15:35:52.494

This is actual data in my database table, but in the datatable I get this:

2019-11-19T10:05

The date format is wrong.

How can i solve this?

The format is not wrong, The T is just a standard (ISO 8601) way to delimit the time. — Shail_bee, Nov 19 '19 at 10:36

score 0 · Answer 1 · answered Nov 19 '19 at 10:54

The date format is wrong.

The format is not wrong, The T is just a standard (ISO 8601) way to de-limit the time. To remove T from your datetime string you could format your string using pure Javascript something like this or you can use any other library like moment. Take a look here for formatting using moment js.

score 0 · Answer 2 · edited Nov 19 '19 at 11:26

0

In columnDefs, add your target column

$(document).ready( function () {
  var table = $('#example').DataTable({

    columnDefs:[{targets:4, render:function(data){
      return moment(data).format('MMMM Do YYYY'); 
    }}]
  });
});

In targets put your column number and In format put the format you want to display. You can try with different format follow this below link

click here for demo

edited Nov 19 '19 at 11:26

Ram Anugandula

582
4
15

answered Nov 19 '19 at 11:00

abhinavsinghvirsen

1,853
16
25

score 0 · Answer 3 · answered Nov 20 '19 at 17:25

If you don't necessarily need it to be a date type, you could try to cast the timestamp to text in your select statement when you retrieve it from the database, like this:

SELECT TO_CHAR(NOW(),'dd/MM/YYYY hh:mm:ss') AS date_time

Here is more info about formatting using TO_CHAR.

Datatable timestamp wrong format

3 Answers3