# Select query return null only when I add TimeStamp column

**URL:** <https://forum.inductiveautomation.com/t/select-query-return-null-only-when-i-add-timestamp-column/52214>\
**Category:** Ignition\
**Tags:** ignition80, database\
**Created:** [October 21, 2021, 3:49pm UTC](https://forum.inductiveautomation.com/t/select-query-return-null-only-when-i-add-timestamp-column/52214 "2021-10-21T15:49:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MED](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@MED](https://forum.inductiveautomation.com/u/MED)\
**Post date:** [October 21, 2021, 3:49pm UTC](https://forum.inductiveautomation.com/t/select-query-return-null-only-when-i-add-timestamp-column/52214/1 "2021-10-21T15:49:33Z")

</div>

Hello experts!

I’m new with ignition. I’m trying to practice some named query for training purpose. I set connection with MS SQL server database and I was able to get data using SELECT named query. My problem is when I add EventTimeStamp column, the query don’t return result however when I’m running this query in SSMS it return result.  
Thanks in advance!

 ![select](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/96f26f7504f5eb3f8eb94f30c75e78ef1f695cc3.png)

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [October 21, 2021, 5:45pm UTC](https://forum.inductiveautomation.com/t/select-query-return-null-only-when-i-add-timestamp-column/52214/2 "2021-10-21T17:45:41Z")

</div>

What if you use just ConditionEvent in your from statement?

---

<div class="post-metadata">

**Author:** ![MED](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@MED](https://forum.inductiveautomation.com/u/MED)\
**Post date:** [October 21, 2021, 5:48pm UTC](https://forum.inductiveautomation.com/t/select-query-return-null-only-when-i-add-timestamp-column/52214/3 "2021-10-21T17:48:21Z")

</div>

Thank you for replying, I tested it but same result.
