[Grafana 5.1 on Ubuntu 18.04, data from MS SQL 2008]
Hi, have data in an old, dusty MS SQL server, where datetimes are recorded in local time, which is Pacific Time.
No, I’m not able to change this. :-/
Unfortunately Grafana is subtracting 7 hours from all our data because it thinks it is in UTC. Changing Browser time to UTC at Grafana does the opposite of what I need and doubles the problem.
I’ve tried modifying the datetimes with SQL queries, but that conflicts with the time filter, so can’t zoom in further than 12 hours:
SELECT
dateadd(hour, datediff(hour,getdate(),getutcdate()), Time_Stamp) as time
FROM
Data_Table
WHERE
$__timeFilter(Time_Stamp)
Not sure what to do. Servers are in Pacific Time. Grafana server hardware is in UTC but OS set to Pacific Time. Open to changing Ubuntu server to UTC, but not sure that will make a difference.
Need Grafana to leave the times from this datasource alone. How do I do that?