I realize that data is stored in the database in UTC.
Select correctly displays recent data as EST (EasternStandardTime) but we are currently on EDT (EasternDaylightTIme).
How can We display the time as EDT?
select temperature from ruuvi_measurements where time > now()-1m AND “mac”=‘F7FA744A1E1A’ tz(‘EST’)
Tue May 7 11:13:53 EDT 2019