# Ignition 8.1.0rc1 sql date issue

**URL:** <https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558>\
**Category:** Ignition\
**Tags:** database\
**Created:** [October 10, 2020, 7:04am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558 "2020-10-10T07:04:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [October 10, 2020, 7:04am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558/1 "2020-10-10T07:04:37Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/5/852a726f5654179347ea58b5af5336d0ed6cb352.png)  
In my previous ignition 8.0.10RC1, if I select a data from a sql table it will not contain the red line highlight data  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/0/d05a63a0a2228c92d1becfe21bd0f14c91075022.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/e/2e6f793b66d24a685664485f524c1c440c505d70.png)  
It will only show 2020-05-13 this date, time will not have  
but after update to 8.1.0RC1 it will contain the time, this is a bug? How can I keep the old logic only get the date instead of the time?

---

<div class="post-metadata">

**Author:** ![dustin.cooper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dustin.cooper/32/29963_2.png) [@dustin.cooper](https://forum.inductiveautomation.com/u/dustin.cooper)\
**Post date:** [October 10, 2020, 12:21pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558/2 "2020-10-10T12:21:03Z")

</div>

If you are displaying the data in a power table then you can use the table customizer to format the “Date” column date format. Choose “yyyy-mm-dd” from the list.

---

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [October 10, 2020, 1:44pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558/3 "2020-10-10T13:44:57Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/3/b3a63d717d9f8b31ee255f385678c03573412453.png)  
thanks for your input, I have tried, in the power table , if I change the format, it will show correct in the table  
but in dropdown list, the select label still contain the extra time, this problem not have before I change to ignition 8.1.0 RC1  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c1c46d8d92a8ccc2419b19b382885dda6cd47fd7.png)

---

<div class="post-metadata">

**Author:** ![dustin.cooper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dustin.cooper/32/29963_2.png) [@dustin.cooper](https://forum.inductiveautomation.com/u/dustin.cooper)\
**Post date:** [October 16, 2020, 1:55am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558/4 "2020-10-16T01:55:29Z")

</div>

I’m not sure if there is something different under the hood with how Ignition is handling the “date” SQL type returned from your table query, but another work around would be to do a statement like this in your query:

```auto

SELECT CONVERT(VARCHAR(10), Date, 111)
FROM YourTable
WHERE SomeConditionIsTrue

```

This will force the value to be returned as a string.

---

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [October 16, 2020, 4:48am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558/5 "2020-10-16T04:48:43Z")

</div>

> [@dustin.cooper](#):
>
> ARCHAR

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/9442dbb66c86b176c2286f1b336aef37d9f9cccf.png)  
I use 113， then it works