In jqGrid, how to format timestamp to dd/mm/yyyy format

Question

My application send timestamp data to jqgrid (like "1268913728759").

now i want to format it like dd/mm/yyyy.

In jqGrid I added following line but it doesn't worked

{name:'testDate',index:'testDate', width:100, formatter:'date', formatoptions: {srcformat: 'ts',newformat:'d/m/Y'}}

Answer 1

The correct seetings for this case should be like this:

formatter:'date', formatoptions: {srcformat: 'U', newformat:'d/m/Y'}

The 'U' is format character for 'Seconds since the Unix Epoch' date format.

Answer 2

Try this:

formatter: function (cellValue, opts, rwd) {
    if (cellValue) {
        return $.fn.fmatter.call(this, "date", new Date(cellValue), opts, rwd);
    } else {
        return '';
    }
}

The correct seetings for this case should be like this:

formatter:'date', formatoptions: {srcformat: 'U', newformat:'d/m/Y'}

The 'U' is format character for 'Seconds since the Unix Epoch' date format.

The timestamp like "1268913728759" means milliseconds not seconds since the Unix Epoch