# OSISOFT Pi JDBC timestamp

**URL:** <https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605>\
**Category:** Ignition\
**Created:** [June 10, 2022, 12:41pm UTC](https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605 "2022-06-10T12:41:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [June 10, 2022, 12:41pm UTC](https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605/1 "2022-06-10T12:41:33Z")

</div>

Hello,

I am getting data from Pi with Ignition 8.1.11 using a JDBC connector.

My issue is when I select data from picomp2 (value and time), the returned dataset cannot be written in a dataset tag.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d8aad2150b70128dd64f4a606cf1ace916e30d90.png)

It seems the datetime format returned by Pi is not compatible with the datetime format used by Ignition. I could convert it to string, but then I won’t be able to show the data in a trend chart…

Any idea?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 10, 2022, 12:50pm UTC](https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605/2 "2022-06-10T12:50:25Z")

</div>

That is a known bug–the datatype whitelist omitted `java.sql.Timestamp`. It has been fixed, but I don’t recall what version.

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [June 10, 2022, 1:58pm UTC](https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605/3 "2022-06-10T13:58:45Z")

</div>

Is there a workaround?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 10, 2022, 2:23pm UTC](https://forum.inductiveautomation.com/t/osisoft-pi-jdbc-timestamp/60605/4 "2022-06-10T14:23:08Z")

</div>

Not for storage in a dataset tag, no. Upgrade is the only option.

Edit: well, you could reprocess the dataset instantiating a `java.util.Date` wherever you have a `java.sql.Timestamp`.