So Our database has a column BigInt REVISIONTS used as part of java Hibernate Envers

It initially contained timestamps from Java Date. 

E.g) `ts=1561637560383`
I used to convert to Date using `new Date(ts)`

But since Date cannot contain timezones and we needed UTC date, we had to store UTC directly as BigInt and applied a fix suggested by hibernate. Because of this now our timestamps are like this

E.g) `ts=20190827202449` now this is not a timestamp anymore but an actual UTC LocaleDateTime stored as bigint

Now querying this i get long and if I use `new Date(ts)` i am getting incorrect date of course since this is not a timestamp but Hibernate Date with Temporal.Timestamp stored the UTC as is.

I am thinking of converting Long to string and use formatting to convert back when retrieving. 

Are there any other cleaner method of converting ?

UTC fix for Envers

[How to save UTC (instead of local) timestamps for Hibernate Envers revision info?](https://stackoverflow.com/questions/37748142/how-to-save-utc-instead-of-local-timestamps-for-hibernate-envers-revision-info)