4 Replies Latest reply on Sep 12, 2019 5:24 AM by eduard.drenth

    SQL query to get a human readable display of the *number* REVINFO.timestamp ?

    faridc

      Hello

       

      I just migrate a project to Hibernate Envers : it works fine :-)

       

      EnversHibernateToolTask generated for oracle the table REVINFO with the column timestamp number(19,0)

       

      For some legacy reasons, we need to display with a SQL query this numeric column timestamp as a human readable date.

       

      Does someone succed to do it in SQL ?

       

      The column is not of timestamp type but number type (choice of EnversHibernateToolTask  for Oracle dialect)

       

      Thank you