date Diff not appearing in Datagrid

Monu

I have set the query to the data grid but it does not show the date diff value. The Object name and ownername values are populated in the datagrid but the date diff column is empty. The query is as below and the code is also provided.

Query:

select r_object_id,object_name,DATEDIFF(day,"r_creation_date",DATE(NOW)) as days,owner_name from ****_folder where <condition>

Code:

Datagrid datagrid = (Datagrid)getControl(NAME, <CLASS>);

datagrid.getDataProvider().setDfSession(getDfSession());

datagrid.getDataProvider().setQuery(strQuery);

setCustomAttributesToDataGrid(true, REPORT_DATA_GRID);

Jsp

<%-- header row with column titles --%>

<tr class='colHeaderBackground'>

<dmf:celllist>

<%-- object name cell template --%>

  <dmf:celltemplate field='object_name'>

  <th scope='col' align='center' class='doclistfilenamedatagrid objectlistheaderspacing'>

  dmf:datasortlink name='sortobjectnamelink' datafield='object_name' cssclass='doclistbodyDatasortlink'/>

  </th>

  </dmf:celltemplate>

<%-- Number Of Days cell template --%>

  <dmf:celltemplate field="days">

  <th scope='col' align='center' class='doclistfilenamedatagrid'>

  <nobr><dmf:datasortlink name='sort4' mode='numeric' datafield="days" cssclass='doclistbodyDatasortlink' /></nobr>

  </th>

  </dmf:celltemplate>

<%-- Owner Name --%>

  <dmf:celltemplate field='owner_name'>

  <th scope='col' align='center'>

  <dmf:datasortlink name='sortownername' datafield='owner_name' cssclass='doclistbodyDatasortlink'/>

  </th>

  </dmf:celltemplate>

  </dmf:celllist>        

</tr>

<dmf:datagridRow cssclass="defaultDatagridRowStyle" altclass="defaultDatagridRowAltStyle">

      <td>

   <dmf:label datafield="object_name" encodelabel="false"/>

       </td>

       <td>

        <dmf:label datafield='days' encodelabel="false" />b

</td>

        <td>

        <dmf:label datafield="owner_name" encodelabel="false"/>

        </td>

</dmf:datagridRow>

sudheerreddy

It will come..

JSP:

<dmf:datagridRowTd nowrap="true" scope='row'>

                            <dmf:label datafield="days" />

                        </dmf:datagridRowTd>

JAVA:

Datagrid datagrid = null;

datagrid = (Datagrid) getControl("ddl", Datagrid.class);

datagrid.getDataProvider().setDfSession(getDfSession());

datagrid.getDataProvider().setQuery("select r_object_id,object_name,datediff(day, r_creation_date, date(now))as days,owner_name from ****_folder where <condition>");

datagrid.getDataProvider().refresh();

datagrid.getDataProvider().setCurrentPage(1);