Archive
Highlighted

DB Query with time parameter

Communicator

Hi!

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

| dbxquery query="SELECT Name, Timestring FROM myTable WHERE Timestring >= ? ;"  connection="DB2" params="1806211100"

This works well and now my question, how can I calculate this "1806211100" Timestring whitin that search and append it as the params Parameter?

Thanks
Rob

Tags (1)
0 Karma
Highlighted

Re: DB Query with time parameter

Builder

Hello @RobertRi,

where doas the Paameter come from? Is it the result of a search query?

0 Karma
Highlighted

Re: DB Query with time parameter

Communicator

Hi! The query is embedded in a form search and via a time token, the user has the Chance to define the time

0 Karma