# Sqlt\_data {variable} t\_stamp **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [March 12, 2021, 11:27am UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397 "2021-03-12T11:27:23Z")\ **Posts on this page:** 9\ **Page:** 1
**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, 11:27am UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/1 "2021-03-12T11:27:23Z")
Hello, how can I make a query that search in all registers? Should i make a variable for year and month? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/7/87cb8fdef17dc36813f4163eae40f98fc92400b7.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 12, 2021, 11:36am UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/2 "2021-03-12T11:36:41Z")
Use the tag history binding. It uses all appropriate tables for the time range you give it. ---
**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, 12:01pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/3 "2021-03-12T12:01:48Z")
Is not any way to do it with SQL? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 12, 2021, 12:12pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/4 "2021-03-12T12:12:53Z")
Not in a single binding, no. You would need to use a union that repeats your query as many times as time ranges indicate. Complicated. Tag history bindings and functions do this for you. ---
**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, 1:29pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/5 "2021-03-12T13:29:44Z")
How can we make a time filter in that case? for example just sow the register between 0 am to 8 am? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 12, 2021, 2:08pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/6 "2021-03-12T14:08:53Z")
Tag History Bindings allow you to specify the date/time start and end. ---
**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:41am UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/7 "2021-03-15T06:41:36Z")
I mean, to filter every day the data range. If i select one data range(1 week), and i just want to see some hour at day(2pm to 3pm). I have made other filters abiables in the table but this as i understand is more easy to make in SQL, how can i make in the tag history bildings? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 15, 2021, 12:42pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/8 "2021-03-15T12:42:17Z")
I would use a history binding for the full time span on a custom component and then post-process that dataset to apply the additional conditions. Naturally, I would use my own [view()](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids) expression function for the post-processing. (: ---
**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, 12:54pm UTC](https://forum.inductiveautomation.com/t/sqlt-data-variable-t-stamp/44397/9 "2021-03-15T12:54:50Z")
I was doing that, make some variables to filter in a table. but is a manual work… Thanks any how. 😀