How to get last 5 days and 24 Days data in posgres with one service

[yasmalik]

I have one service which has one input as period I put days value it give error but when put it hardcode values then it works fine

[raluca_edu · Accepted solution]

Hi,

Try this:

select "Date","Temp"

from public."Temperature" where "Date" between (now()-[[period]]::interval) and now();

On my end is working fine.

Hope it helps,

Raluca Edu

[yasmalik]

Thank you so much It's working