Get the value of a sensor at a specific time

[petro]

This post here will help.

Get temperature from yesterday

After a lot of trial and error I taped this SQL query together: # Get the sensor value at a specified time - platform: sql queries: - name: Temp. piscina ontem query: "SELECT * FROM states WHERE entity_id = 'sensor.temperatura_piscina' ORDER BY ABS(strftime('%s', created) - strftime('%s', '2019-11-07 12:00:00', 'utc')) LIMIT 1;" column: 'state' Although the time (hour) seems shifted in the state window, it seems that it’s getting the right value. Timezones can be a …