# Passing DateTime End Up Having Date Only

**URL:** <https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132>\
**Category:** Ignition\
**Tags:** scripting, perspective\
**Created:** [February 24, 2026, 12:53am UTC](https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132 "2026-02-24T00:53:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![john.hadikusumo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.hadikusumo/32/75487_2.png) [@john.hadikusumo](https://forum.inductiveautomation.com/u/john.hadikusumo)\
**Post date:** [February 24, 2026, 12:53am UTC](https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132/1 "2026-02-24T00:53:18Z")

</div>

I am working on Ignition 8.3 project and found something bothered me. I notice that evertytime i tried to pass datetime data into my scripting method, only date that was written onto my database table.

My table is simple. It has 2 fields that has DateTime data type.

**Picture 1.**

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/6/567b70af720b41e2582e548920aac18bf3b166d9.png)

The stored procedure for insertion also simple. I had tested and worked as what it was suppose to.

**Picture 2.**

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

This is my scripting that calling the stored procedure and passing the parameters into it.

**Picture 3**

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

This is my test console. When i worked on ignition 8.1, i didn’t get a problem at all. All date and time was correctly written into database. But on Ignition 8.3 seems not working completely correct.

**Picture 4**

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/364a101635f6eb8aba1462e3613a2f61e9b91e69.png)

So if i execute the script above, i only get Date only without the times.

Picture 5

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/17f4edd627e3940cbcb1261f472fb17ccca3626d.png)

Just wondering if you know how to mitigate this issue or at least pin point me out where i made a mistake.

Thank you

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 24, 2026, 2:46am UTC](https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132/2 "2026-02-24T02:46:44Z")

</div>

`system.db.DATE` is the wrong constant; you should be using `system.db.TIMESTAMP`. If it worked before, it's likely because your JDBC driver was being less strict, but the JDBC driver provided for your DB in 8.3 (correctly) truncates to a date only.

---

<div class="post-metadata">

**Author:** ![john.hadikusumo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.hadikusumo/32/75487_2.png) [@john.hadikusumo](https://forum.inductiveautomation.com/u/john.hadikusumo)\
**Post date:** [February 24, 2026, 2:56am UTC](https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132/3 "2026-02-24T02:56:30Z")

</div>

Thank you

---

<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:** [February 24, 2026, 1:14pm UTC](https://forum.inductiveautomation.com/t/passing-datetime-end-up-having-date-only/114132/4 "2026-02-24T13:14:45Z")

</div>

_Psssst!_ Mark the comment that _helped you_ as the solution, not your own "Thank you".