# Insert datetime tag value into SQL database using NestedQueries results in null value

**URL:** <https://forum.inductiveautomation.com/t/insert-datetime-tag-value-into-sql-database-using-nestedqueries-results-in-null-value/37170>\
**Category:** Ignition\
**Created:** [July 28, 2020, 9:25pm UTC](https://forum.inductiveautomation.com/t/insert-datetime-tag-value-into-sql-database-using-nestedqueries-results-in-null-value/37170 "2020-07-28T21:25:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yfactor](https://avatars.discourse-cdn.com/v4/letter/y/e79b87/32.png) [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\
**Post date:** [July 28, 2020, 9:25pm UTC](https://forum.inductiveautomation.com/t/insert-datetime-tag-value-into-sql-database-using-nestedqueries-results-in-null-value/37170/1 "2020-07-28T21:25:11Z")

</div>

Hi there,  
I am trying to insert a datetime tag value into a sql table (column data type: datetime) using NestedQueries. It will insert a row with NULL value…

query- INSERT INTO dateTime(dateTime) VALUES(:x)  
where x is a parameter (data Type DateTime, query type Update Query)

I want to insert something like this ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/15d535dc438a3992788764d2a5fe0f1f93a8dda0.png)

but I ended up getting something like this ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/d/cd983af1723a656f0ce1908dd4e896c5c0a4885a.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/f/0fd7c2d40f79bd3da23b4321790bc2454eef9c06.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/00ba1be232538d93ea06d4b1a5efa6295c6e3495.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/6/4683966e0da9c3fafb5a87a47ec006dcb9c766e0.png)

Cheers

---

<div class="post-metadata">

**Author:** ![bpreston](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\
**Post date:** [July 29, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/insert-datetime-tag-value-into-sql-database-using-nestedqueries-results-in-null-value/37170/2 "2020-07-29T13:34:24Z")

</div>

Try putting quotes around your variable name for your parameter in the runNamedQuery call like:

```auto
system.db.runNamedQuery("DateTime", {"x":date})

```