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

**URL:** <https://community.grafana.com/t/query-with-8-2-4-results-epoch-time-while-7-5-9-results-2021-11-18t0000z/56346>\
**Category:** Developers & API\
**Tags:** postgres, timestamp\
**Created:** [November 16, 2021, 2:02pm UTC](https://community.grafana.com/t/query-with-8-2-4-results-epoch-time-while-7-5-9-results-2021-11-18t0000z/56346 "2021-11-16T14:02:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharingideas](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@sharingideas](https://community.grafana.com/u/sharingideas)\
**Post date:** [November 16, 2021, 2:02pm UTC](https://community.grafana.com/t/query-with-8-2-4-results-epoch-time-while-7-5-9-results-2021-11-18t0000z/56346/1 "2021-11-16T14:02:16Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [November 30, 2021, 3:02am UTC](https://community.grafana.com/t/query-with-8-2-4-results-epoch-time-while-7-5-9-results-2021-11-18t0000z/56346/2 "2021-11-30T03:02:36Z")

</div>

@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](https://grafana.com/docs/grafana/latest/panels/transformations/types-options/#convert-field-type)…

---

<div class="post-metadata">

**Author:** ![anon70503803](https://avatars.discourse-cdn.com/v4/letter/a/8797f3/32.png) [@anon70503803](https://community.grafana.com/u/anon70503803)\
**Post date:** [November 30, 2021, 3:05am UTC](https://community.grafana.com/t/query-with-8-2-4-results-epoch-time-while-7-5-9-results-2021-11-18t0000z/56346/3 "2021-11-30T03:05:51Z")

</div>

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

[grafana/grafana#36404](https://github.com/grafana/grafana/issues/36404)