Subtract 14 days from system date

2.3k Views Asked by At

I am using the following code to give me the system date in BODS, to_char(sysdate(),'YYYYMMDDHHMISS'), I have the system date returning correctly, but am unable to subtract days.

FAGLFLEXA.TIMESTAMP >= "MISSING CODE HERE" and FAGLFLEXA.TIMESTAMP <= to_char(sysdate(),'YYYYMMDDHHMISS')

1

There are 1 best solutions below

0
On

You can subtract days from a date by subtracting a whole number. Also, for some reason you are using sysdate() which is not proper Oracle format.

to_char(sysdate-14,'YYYYMMDDHHMISS')