Grafana receives epoch timestamp 1 hour ahead from SQL Server

Grafana presumes UTC, you can try with the Dashboard Timezone
But I found a work around, although people will disagree is,

Offset your time with DATEADD(HOUR,-1,Time) AS Time

And Offset your time filter accordingly

Where Time BETWEEN DATEADD( HOUR,+1,$__timeFrom() )
AND DATEADD( HOUR,+1,$__timeTo() )

Takes a bit of messing and then Daylight Savings messes it up again

1 Like