https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398874#M168749 <P>Hi!</P> <P>I have installed the DB Connect App and want to use a Query in which I have to pass a time based value as a Parameter</P> <PRE><CODE>| dbxquery query="SELECT Name, Timestring FROM myTable WHERE Timestring &gt;= ? ;" connection="DB2" params="1806211100" </CODE></PRE> <P>This works well and now my question, how can I calculate this "1806211100" Timestring whitin that search and append it as the params Parameter?</P> <P>Thanks<BR /> Rob</P> Thu, 21 Jun 2018 10:29:42 GMT RobertRi 2018-06-21T10:29:42Z https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398874#M168749 <P>Hi!</P> <P>I have installed the DB Connect App and want to use a Query in which I have to pass a time based value as a Parameter</P> <PRE><CODE>| dbxquery query="SELECT Name, Timestring FROM myTable WHERE Timestring &gt;= ? ;" connection="DB2" params="1806211100" </CODE></PRE> <P>This works well and now my question, how can I calculate this "1806211100" Timestring whitin that search and append it as the params Parameter?</P> <P>Thanks<BR /> Rob</P> Thu, 21 Jun 2018 10:29:42 GMT https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398874#M168749 RobertRi 2018-06-21T10:29:42Z https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398875#M168750 <P>Hello @RobertRi,</P> <P>where doas the Paameter come from? Is it the result of a search query?</P> Thu, 21 Jun 2018 12:05:26 GMT https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398875#M168750 poete 2018-06-21T12:05:26Z https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398876#M168751 <P>Hi! The query is embedded in a form search and via a time token, the user has the Chance to define the time</P> Thu, 21 Jun 2018 12:49:25 GMT https://community.splunk.com/t5/Splunk-Search/DB-Query-with-time-parameter/m-p/398876#M168751 RobertRi 2018-06-21T12:49:25Z