4 Replies Latest reply on May 25, 2012 12:14 AM by swetha.dts

    How to apply date functions or TO_CHAR funstions for an audited timestamp column?



      Am new to envers and i am struck with an issue related to date funtions.

      In this case the insertdate column is stored as timestamp in the DB.

      But i want to apply the condition till seconds only so i need to put some date function to format the datecolumn.


      AuditReader reader = AuditReaderFactory.get(



      AuditQuery query = reader.createQuery().forRevisionsOfEntity(getPersistentClass(),true,true);




      in this case how can i apply the function to the revision property (updateddate)?

      Thanks in Advance.