# SQL Tag DateTime Format

**URL:** <https://forum.inductiveautomation.com/t/sql-tag-datetime-format/4941>\
**Category:** Ignition\
**Created:** [August 7, 2012, 9:16am UTC](https://forum.inductiveautomation.com/t/sql-tag-datetime-format/4941 "2012-08-07T09:16:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aidamcg](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\
**Post date:** [August 7, 2012, 9:16am UTC](https://forum.inductiveautomation.com/t/sql-tag-datetime-format/4941/1 "2012-08-07T09:16:30Z")

</div>

Hi

I noticed this since I upgraded to version 7.5 that when you create new sql date time tags that the string format is not date time and defaults to numeric. Not a major issue as it can be changed in metadata but adds another step

Regards

Aidan  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b6a56048721137bc584c4377fbbe9773eaea0e6e.png)

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [August 7, 2012, 4:19pm UTC](https://forum.inductiveautomation.com/t/sql-tag-datetime-format/4941/2 "2012-08-07T16:19:02Z")

</div>

I will pass this on to the developers, thanks for bringing it to our attention.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [October 30, 2014, 7:21pm UTC](https://forum.inductiveautomation.com/t/sql-tag-datetime-format/4941/3 "2014-10-30T19:21:26Z")

</div>

We’ve been unable to reproduce this behavior.