Passing a date to dbquery

[obrienk]

Hi,
I would like to run a simple query against a database using splunk.
I would like to run the query as part of a dashboard.

The query is as follows:

| dbquery "DATEBASE_NAME" limit=1000 "select tr.* from schema.table tr where tr.date = '27-AUG-2014'

I would like the query to run against the date in question. So it would be like:

| dbquery "DATEBASE_NAME" limit=1000 "select tr.* from schema.table tr where tr.date = sysdate

I am having trouble defining the date as the dbquery needs to be the first item on the search line.

Can anyone help?
Thanks,

[obrienk · Accepted solution]

I got this working by using the date in the database

ie. tr.date = to_date(current_date)