I’m trying to run a query without a time stamp column. In MySQL I can do:
SELECT NOW() as ‘time’
And that works fine for the MySQL Servers. However when I try:
SELECT GETDATE() as time
I get no results in a time series. But it will show up in a table:
What do I need to do?
What version of grafana are you on?
Grafana v6.7.4 (NA) is the version
That could be the issue. You are one of the oldest version of grafana
Any reason you cannot update?
It’s in a closed secure location in production. We cannot install from repo
select GETDATE() as time, 77 value, 'jama' as metric
datetime by itself does not. odd
Now I get the following result:
getdate is not UTC, you will need to provide a utc date time which grafana requires. maybe GETUTCDATE()
your issue is not grafana but the data you provided it.
GETUTCDATE does the same behavior