# Use interval in SQL Query **URL:** \ **Category:** Ignition\ **Tags:** vision, ignition78, scripting, ignition79, ignition80\ **Created:** [November 30, 2020, 1:32pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044 "2020-11-30T13:32:16Z")\ **Posts on this page:** 7\ **Page:** 1
**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:** [November 30, 2020, 1:32pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/1 "2020-11-30T13:32:16Z")
Hello everybody! Can someone help me with the following, I have tags that should be kept in memory for about 90 days, what should I do to make these values appear in the table using a time interval with some time step? when I want to use the first option, the tags are not displayed and are not written to memory. In the second option, I write to memory but I cannot set the time step! ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/d/ddcc0c8e305c608141825c313f24ee52a4622927.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1dc762c5c8621ed1799ee5e982ecf02510dd7d48.png) it will be use on the next picture ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/2/120dc424e9a474bff5d62f04782f1cc89e7f794d.png) ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 30, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/2 "2020-11-30T13:41:03Z")
In your first image (/method) you are at the folder level, drill down to the tags you want and drag over to the right. In your second image (/method), instead of ‘{StartString}’ put a ?.. this will bring a new window at the bottom, in there click on the button on the top right and select your start param. Do the same for EndString ---
**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:** [November 30, 2020, 2:10pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/4 "2020-11-30T14:10:16Z")
in first variant i added some tag to historical tag but it doesn `t exist in folder what you see. in second variant startstring and endstring time work correctly, but i can` t add step for it! ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 30, 2020, 3:02pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/5 "2020-11-30T15:02:21Z")
Have you watched IU? e.g: [https://www.inductiveuniversity.com/videos/parameters/8.1](https://www.inductiveuniversity.com/videos/parameters/8.1) [https://www.inductiveuniversity.com/videos/tag-historian-query/8.1](https://www.inductiveuniversity.com/videos/tag-historian-query/8.1) ---
**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:** [November 30, 2020, 3:24pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/6 "2020-11-30T15:24:13Z")
No that, but i saw [https://docs.inductiveautomation.com/display/DOC79/Basic+SQL+Query#BasicSQLQuery-WorkingwithDates](https://docs.inductiveautomation.com/display/DOC79/Basic+SQL+Query#BasicSQLQuery-WorkingwithDates) and demo project ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [November 30, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/7 "2020-11-30T15:38:14Z")
Do you get the expected dataset returned when running the SQL only in DB query browser (Tools menu in designer). Watch the IU vids, change the version to 7.9 on IU menu ---
**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:** [December 14, 2020, 1:31pm UTC](https://forum.inductiveautomation.com/t/use-interval-in-sql-query/41044/8 "2020-12-14T13:31:00Z")
i will look later, thank`s!