Query with 8.2.4 results epoch time while 7.5.9 results 2021-11-18T00:00:00Z

Grafana Developers & API
,
1

I have data source as Postgres13.
My column contents are as below (given few rows only)

“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-07”
“2021-10-14”
“2021-10-14”
“2021-10-14”
“2021-10-14”
“2021-10-14”
“2021-10-14”
“2021-10-14”
“2021-10-14”

If i add variable in Grafana with 8.2.4 with query

select distinct from where expirydate >= current_date order by 1 ASC limit 12

I am getting output as epoch time as below
1637193600000

1637798400000

1638403200000

1639008000000

1639612800000

1640217600000

1640822400000

1641427200000

1642032000000

1643241600000

1648684800000

1656547200000

While if I run same query in Grafana 7.5.9 to add variable I am getting

2021-11-18T00:00:00Z

2021-11-25T00:00:00Z

2021-12-02T00:00:00Z

2021-12-09T00:00:00Z

2021-12-16T00:00:00Z

2021-12-23T00:00:00Z

2021-12-30T00:00:00Z

2022-01-06T00:00:00Z

2022-01-13T00:00:00Z

2022-01-27T00:00:00Z

2022-03-31T00:00:00Z

2022-06-30T00:00:00Z

What could be the issue?

2

@sharingideas are you saying that you want to convert that epoch format into a more human-readable timestamp?

I can’t say why this is happening or how to fix the core problem. But a workaround might be to fiddle with the Convert field type transformation…

3

also, this issue might be related. what do you think?

grafana/grafana#36404