# Filtering Time range in SQL Query

**URL:** <https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395>\
**Category:** Ignition\
**Tags:** database, ignition80\
**Created:** [March 12, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395 "2021-03-12T09:27:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![OscarLucas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/oscarlucas/32/6417_2.png) [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\
**Post date:** [March 12, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395/1 "2021-03-12T09:27:36Z")

</div>

Hello  
I would like to filter the data in a period of time.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/29eddb7a8299870221c92692a3cc840dcf2c4534.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d86d7d50962b6f83941d709ab13b23bc32c210ce.png)  
I suppose that the failure is coming from the dateFormat i try  
`dateFormat(toDate(` `"2003-9-14 8:00:00"` `), ` `"yyyy-MM-dd 00:00:00"` `)`  
but it dosent work.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/9/99e79226fa893f20fefb218e1222ff227eede0d3.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 12, 2021, 11:17am UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395/2 "2021-03-12T11:17:35Z")

</div>

The ORDER BY clause needs to come after the WHERE clause.

---

<div class="post-metadata">

**Author:** ![Andrii.Randiuk](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@Andrii.Randiuk](https://forum.inductiveautomation.com/u/Andrii.Randiuk)\
**Post date:** [March 12, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395/3 "2021-03-12T12:43:29Z")

</div>

SELECT \* FROM yourtable  
(Timestamp Between ‘{Root Container.Period Mode.Start Date.Start Date Calendar.date}’ AND ‘{Root Container.Period Mode.End Date.End Date Calendar.date}’)

---

<div class="post-metadata">

**Author:** ![OscarLucas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/oscarlucas/32/6417_2.png) [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\
**Post date:** [March 15, 2021, 6:48am UTC](https://forum.inductiveautomation.com/t/filtering-time-range-in-sql-query/44395/5 "2021-03-15T06:48:33Z")

</div>

Thanks