ReportServer Forum

Patryx

Member

Registered: 2019-03-25

How to read datetime from timestamp defined as bigint in your RS db?

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

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: How to read datetime from timestamp defined as bigint in your RS db?

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