# Ignition Database datetime data input to View's param

**URL:** <https://forum.inductiveautomation.com/t/ignition-database-datetime-data-input-to-views-param/98655>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [November 15, 2024, 9:48am UTC](https://forum.inductiveautomation.com/t/ignition-database-datetime-data-input-to-views-param/98655 "2024-11-15T09:48:05Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 15, 2024, 10:47am UTC](https://forum.inductiveautomation.com/t/ignition-database-datetime-data-input-to-views-param/98655/2 "2024-11-15T10:47:01Z")

</div>

Standard practice is to store date and time as DATETIME type in the database. Don't convert it to a string until you need to display it to a human. In addition, saving in UTC will avoid lots of problems with timezones and daylight saving.

Show us your query and someone may have suggestions for improvement. See [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-database-datetime-data-input-to-views-param/98655)._