DB Query with time parameter

[RobertRi]

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

[poete]

Hello @RobertRi,

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

[RobertRi]

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