Dynamic SQL query with PostgreSQL and Thingworx

I'm trying to fetch data from PostgreSQL database.

Query,

select 
 entry_timestamp + interval '30 minutes' as offset_timestamp,
 entry_timestamp
from 
 sensor_data

I'm trying to pass 30 minutes from Thingworx input.

select 
 entry_timestamp + interval '<dynamic>' as offset_timestamp,
 entry_timestamp
from 
 sensor_data

How to do that?

Best answer by Velkumar

Hi @Sathishkumar_C

You can try something like this. Just pass the whole '30 minutes' (with a single quote) as input to the service

Answer

19-Tanzanite

Hi @Sathishkumar_C

You can try something like this. Just pass the whole '30 minutes' (with a single quote) as input to the service

Author

17-Peridot

Thanks @Velkumar

select 
 entry_timestamp + make_interval(mins => <<offset_interval>>) as offset_timestamp,
 entry_timestamp
from 
 sensor_data

Got a expected output with above code. offset_interval (Ex. 30) is passing from ThingWorx service.

Below one also working as expected,

select 
 entry_timestamp + <<offset_interval>> as offset_timestamp,
 entry_timestamp
from sensor_data

offset_interval (Ex. interval '30 minutes') is passing from ThingWorx service.

Sign up