When doing a direct query against our Oracle database, I was having trouble converting the TS_TIME field in the TS_CHANGES table into a usable format. Serena HelpDesk told me it was a Unix time field and referred me to an online Unix time calculator tool, but they were unable to provide the SQL to convert it. :-(
Once I found out it is stored as Unix time, I was able to google it myself and got this to work:
SELECT DATE '1970-01-01' TS_CHANGES.TS_TIME/86400 as TS_TIME_CONVERTED
However the timestamp was 8 hrs later than what is displayed in my User Workspace report, and 5 hrs later than where our server resides, so not sure where the timestamp is based but this worked for subtracting 8 hrs so that it now matches my User Workspace time zone display:
SELECT (DATE '1970-01-01' TS_CHANGES.TS_TIME/86400) - (8*.0416666) as TS_TIME_MINUS8
Probably not the most elegant but hey I'm not a coder. :-)
Hope this is useful if anyone else has the same question.