Subtract 14 days from system date

Question

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')

Answer 1

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')