# TagHistory time stamp in Oracle Database

**URL:** <https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837>\
**Category:** Ignition\
**Created:** [November 1, 2017, 7:18am UTC](https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837 "2017-11-01T07:18:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dhananjay\_vichare](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dhananjay_vichare/32/74712_2.png) [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\
**Post date:** [November 1, 2017, 7:18am UTC](https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837/1 "2017-11-01T07:18:44Z")

</div>

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 + 8_60_60, ‘19700101’) as newdatetime”** when Database was **MS SQL**.

_Is there any function in Oracle to convert Unix time stamp?_

---

<div class="post-metadata">

**Author:** ![vitor.dasilva](https://avatars.discourse-cdn.com/v4/letter/v/b5ac83/32.png) [@vitor.dasilva](https://forum.inductiveautomation.com/u/vitor.dasilva)\
**Post date:** [November 2, 2017, 9:01am UTC](https://forum.inductiveautomation.com/t/taghistory-time-stamp-in-oracle-database/15837/2 "2017-11-02T09:01:36Z")

</div>

See this link… might give you some clues…  
[https://community.oracle.com/thread/302756](https://community.oracle.com/thread/302756)