Wednesday, October 9, 2013

issue filtering date column in table ADF

 
SELECT  trunc(UPDATE_TS) UPDATE_TS,  // TIMESTAMP
          INSP_ID,
       trunc(LAST_INSP_DATE) LAST_INSP_DATE // DATE
FROM INSP_TABLE

Use Trunc to truncate the timestamp and date to be able to filter data in an af:table

Also use  <af:convertDateTime pattern="MM/dd/yyyy"/> in both table filter as well as input date component

http://dkleppinger.blogspot.com/2011/09/how-to-ignore-time-component-of-date.html

No comments: