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?