SQL Server and Time

Grafana Time Series Panel
, ,
1

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:

image

image
image838×528 14.6 KB

What do I need to do?

2

What version of grafana are you on?

3

Grafana v6.7.4 (NA) is the version

4

That could be the issue. You are one of the oldest version of grafana

Any reason you cannot update?

5

It’s in a closed secure location in production. We cannot install from repo

1 Like
6

this works

select  GETDATE() as time, 77 value, 'jama' as metric

datetime by itself does not. odd

7

Now I get the following result:

image
image1900×849 61.4 KB

1 Like
8

Table shows the data:

image
image1542×626 18.7 KB

1 Like
9

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.

10

GETUTCDATE does the same behavior