I wanted to have a column of data gathered from a mysql timestamp type but didn't want to display the time in the jqgrid column, just the date. Then I wanted to allow a user to see the entire entry, date and time, when hovering over a cell. Here's one way to do it. First create your column including the formatter attribute:
colModel: [
{
name: 'memberid',
index: 'memberid',
hidden:true,
},
{
name: 'lastmod',
index: 'lastmod',
width: 65,
hidden:true,
formatter:stripTime,
sorttype: "text"
},
Then use something like this to format:
function stripTime(cellValue,options,rowObject) {
console.dir(rowObject);
var x= rowObject.lastmod.substring(0,10);
return ''+ x +'';
return rowObject.lastmod;
return rowObject.lastmod.substring(0,10);
}
Show demo