TagHistory time stamp in Oracle Database

I am using Oracle 11G server to log the tag history data.
(Ignition version is 7.8.5 (b2016120813) and Java version is Oracle Corporation 1.8.0_144)

I am trying to convert unix timestamp logged in SQLT_DATA_1_2017_10 table, but not able to convert it.

I was used function “from_unixtime(t_stamp/1000)” when database was MySQL
and “dateadd(second, t_stamp /1000 + 86060, ‘19700101’) as newdatetime” when Database was MS SQL.

Is there any function in Oracle to convert Unix time stamp?

See this link… might give you some clues…