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

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

Best answer by raluca_edu

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

Answer

17-Peridot

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

Author

1-Visitor

Thank you so much 🙂 It's working

Sign up