How to pass timerange filter for Sqlite query

[infofcc3]

How to pass timerange filter for postgres query

Problem Statement : We are using sqlite datasource to build dashboards. we are getting data with below query but we want to filter it based on time range and also real time data. ex: every 6m the dashboard to be refresh and change the values. So, can some one help me to how we can pass the time interval of 6m in query to refresh it every time. Select Date_n_Time, SensorID, Temperature from dht22_temperature_Data Step to achive this follow the steps mention below Step 1: Create table and inser…

Follow the steps