# How to know the current date in a sql query in kibana

**URL:** <https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756>\
**Category:** Elasticsearch\
**Created:** [July 10, 2019, 12:10pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756 "2019-07-10T12:10:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diego\_Benito](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_benito/32/47331_2.png) [@Diego\_Benito](https://discuss.elastic.co/u/Diego_Benito)\
**Post date:** [July 10, 2019, 12:10pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/1 "2019-07-10T12:10:33Z")

</div>

Hi,

Im trying to execute the follow sql query:

GET \_xpack/sql?format=txt  
{  
"query" :""" select level  
from "default-\*" where  
queueName='ASPY\_001\_0200\_RecogidaDatosGISS' and (transactionStatus='2' or transactionStatus = '3') and  
timeStamp = "now-1d/d" """  
}

I need the query to automatically extract the date every day, i dont know if its possible, but if is possible if someone can help me I appreciate it

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 10, 2019, 12:14pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/2 "2019-07-10T12:14:39Z")

</div>

Isn't what is happening when you use `now-1d/d`?

---

<div class="post-metadata">

**Author:** ![Diego\_Benito](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/diego_benito/32/47331_2.png) [@Diego\_Benito](https://discuss.elastic.co/u/Diego_Benito)\
**Post date:** [July 10, 2019, 12:29pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/3 "2019-07-10T12:29:12Z")

</div>

If i run this query , i get the follow error:

 ![Sin%20t%C3%ADtulo](https://us1.discourse-cdn.com/elastic/original/3X/e/5/e500153136ea28df413b2c5ad87d0c67df3a995e.png)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 10, 2019, 12:42pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/4 "2019-07-10T12:42:41Z")

</div>

I see. Have a look at [https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-current-date](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-current-date)

May be that would help.

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [July 10, 2019, 2:15pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/5 "2019-07-10T14:15:46Z")

</div>

@Diego_Benito Indeed, as @dadoonet already mentioned CURRENT\_DATE and CURRENT\_TIME should be used in this case. Also, you can perform date math operations using [intervals](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-datetime-interval), like in this example [here](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-functions-datetime.html#sql-functions-today).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 7, 2019, 2:15pm UTC](https://discuss.elastic.co/t/how-to-know-the-current-date-in-a-sql-query-in-kibana/189756/6 "2019-08-07T14:15:48Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.