Weird timezone problems

ew . maybe it can’t fit what you want: 7 days worth of data but you still want to see the last 7 hours?

I am out of ideas.

side point in your query

date as time,
  weather_attribute as metric,
  measurement value

to remove the word measurement.

I appreciate you trying! Hopefully someone else will be able to chime in with some ideas.

1 Like

Turns out the problem also extends to alerts. I’m getting alerts several hours too late.
Any ideas are appreciated

Try SELECT
UNIX_TIMESTAMP(date) AS “time”,

1 Like

@jrucker did you ever figure this out? I am having the exact same issue.

This fixed it for me! Thanks