Influx cannot display time as daylight savings time

#1

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’)
name: ruuvi_measurements
time temperature


2019-05-07T10:13:45.865455505-05:00 21.78

date
Tue May 7 11:13:53 EDT 2019

#2

Hi @DG12 ,

what is your location ?

you can use tz(‘America/New_York’) for example …

or choose from this list … tz
best regards ,

1 Like
#3

Thank you VERY much!

1 Like