3 Replies Latest reply: Mar 28, 2012 7:41 AM by Farid C RSS

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

Farid C Newbie

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