# Force Transaction group to use smalldatetime

**URL:** <https://forum.inductiveautomation.com/t/force-transaction-group-to-use-smalldatetime/4656>\
**Category:** Ignition\
**Created:** [June 18, 2012, 6:43pm UTC](https://forum.inductiveautomation.com/t/force-transaction-group-to-use-smalldatetime/4656 "2012-06-18T18:43:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![techerdone](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@techerdone](https://forum.inductiveautomation.com/u/techerdone)\
**Post date:** [June 18, 2012, 6:43pm UTC](https://forum.inductiveautomation.com/t/force-transaction-group-to-use-smalldatetime/4656/1 "2012-06-18T18:43:44Z")

</div>

Is there a way to force the transaction group to update the timestamps with smalldatetime instead of datetime in a MSSQL database?

Would I have to use a stored procedure to convert it to smalldatetime?

---

<div class="post-metadata">

**Author:** ![techerdone](https://avatars.discourse-cdn.com/v4/letter/t/9fc348/32.png) [@techerdone](https://forum.inductiveautomation.com/u/techerdone)\
**Post date:** [June 18, 2012, 6:52pm UTC](https://forum.inductiveautomation.com/t/force-transaction-group-to-use-smalldatetime/4656/2 "2012-06-18T18:52:13Z")

</div>

Never mind, I found that I was using ‘yyyy-mm-dd…’ instead of ‘yyyy-MM-dd…’ to create my timestamp tag and this was causing the date to upload incorrectly.  
I found that I can simply change the datatype to smalldatetime in the database after the transaction group has created the table.