# How to use date filter in sql query

**URL:** <https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512>\
**Category:** Dashboards\
**Tags:** time-selection, query-help\
**Created:** [August 30, 2023, 6:30pm UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512 "2023-08-30T18:30:08Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamesbrooks3](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@jamesbrooks3](https://community.grafana.com/u/jamesbrooks3)\
**Post date:** [August 30, 2023, 6:30pm UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/1 "2023-08-30T18:30:08Z")

</div>

I’m very new to Grafana. I’m going the route of writing custom sql queries to populate my panels (however I feel like there must be an easier way). Having said that, I’m noticing the dashboard values do not change when I use the default time selections Grafana gives. Do I have include date filter logic in the query?

```auto
select
  sum(video_duration), 
  viewer_os_family
from grafana_dwh_mux_dimensions
where 
  batch_year='2023' and 
  batch_month='08' and 
  batch_day='25' and
  $__dateFilter(view_time)
group by viewer_os_family

```

This is what I think is right, but it does not return data.

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 30, 2023, 7:20pm UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/2 "2023-08-30T19:20:41Z")

</div>

Welcome @jamesbrooks3

version of grafana?  
datasource type? mysql, mssql, postgres?

---

<div class="post-metadata">

**Author:** ![jamesbrooks3](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@jamesbrooks3](https://community.grafana.com/u/jamesbrooks3)\
**Post date:** [August 30, 2023, 8:12pm UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/3 "2023-08-30T20:12:32Z")

</div>

hi @yosiasz,

I’m using an athena db

Grafana v10.0.3

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 31, 2023, 12:04am UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/4 "2023-08-31T00:04:55Z")

</div>

> [@jamesbrooks3](#):
>
> $\_\_dateFilter(view\_time)

Is viewtime column utc?  
Also what happens when you run this query in athena query tool ?

---

<div class="post-metadata">

**Author:** ![jamesbrooks3](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@jamesbrooks3](https://community.grafana.com/u/jamesbrooks3)\
**Post date:** [August 31, 2023, 12:54am UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/5 "2023-08-31T00:54:38Z")

</div>

yes, according to the data dictionary it’s in UTC

I get this error:  
error querying the database: error executing query: InvalidRequestException: line 3:18: mismatched input ‘=’. Expecting: { RespMetadata: { StatusCode: 400, RequestID: “d93db94c-b7ec-4fe3-8558-138939b894f2” }, AthenaErrorCode: “MALFORMED\_QUERY”, Message\_: “line 3:18: mismatched input ‘=’. Expecting: ” }

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 31, 2023, 12:56am UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/6 "2023-08-31T00:56:12Z")

</div>

What did you run and where did you run it?

---

<div class="post-metadata">

**Author:** ![tekwhat](https://avatars.discourse-cdn.com/v4/letter/t/c57346/32.png) [@tekwhat](https://community.grafana.com/u/tekwhat)\
**Post date:** [August 31, 2023, 6:02am UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/7 "2023-08-31T06:02:01Z")

</div>

Hello @jamesbrooks3, I am rather new to Grafana myself. Have you attempted $\_\_timeFilter() instead of date filter?

---

<div class="post-metadata">

**Author:** ![jangaraj](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/jangaraj/32/39197_2.png) [@jangaraj](https://community.grafana.com/u/jangaraj)\
**Post date:** [August 31, 2023, 8:34am UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/8 "2023-08-31T08:34:24Z")

</div>

Start simple - remove that batch conditions and when you have working examole then add more complexity, e. g. batch conditions. You will see which step generates an error, so you will know what wrong.

Also use query inspector to check generated SQL syntax [How To Use Grafana's Query Inspector to troubleshoot issues](https://community.grafana.com/t/how-to-use-grafanas-query-inspector-to-troubleshoot-issues/2630)

---

<div class="post-metadata">

**Author:** ![jamesbrooks3](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@jamesbrooks3](https://community.grafana.com/u/jamesbrooks3)\
**Post date:** [August 31, 2023, 10:02pm UTC](https://community.grafana.com/t/how-to-use-date-filter-in-sql-query/102512/9 "2023-08-31T22:02:17Z")

</div>

this worked! thank you