You are not logged in.
Hi,
In PostgreSQL database you have a table "rs_revision" with column timestamp given as BIGINT.
How can I read this column to get right timestamp with date and time. I tried to_timestamp(rs_revision.timestamp) but it doesn't return correct and readable date and time.
Thanks in advance,
Patryk
Offline
Hi Patryx,
we use envers for revision management. You can read some information on this here: https://docs.jboss.org/hibernate/envers … onlog.html
Here you can see an example of conversion of the timestamp to date: https://developer.jboss.org/thread/176684
Regards,
Eduardo
Offline