Please help with date calculation

Database

Please help with date calculation

 where ( rain.ftb_btch_id > 0  and ftb1. gwy_strt_tmsp <= ('09/10/2015'(Date, Format 'mm-dd-yyyy')))

I want to replace the date in the code above '09/10/2015' with a calculation to make the date one day prior

to the date when this query is run.

Thanks,

Tags (1)
1 REPLY
Enthusiast

Re: Please help with date calculation

CURRENT_DATE-INTERVAL '1' DAY.