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

@thatjeffsmith how is that written out though, I have tried both inside the date format and outside but am getting an error — Carl Skonieczny, Jun 04 '18 at 17:16
try to_char(sysdate - 7,'yyyymmddhhmiss'). I don't think you want () after your sysdate — Peter M, Jun 04 '18 at 17:23
not sure why you are to_char(sysdate)...just do SYSDATE - 7 to reference this this moment right now, 7 days ago — thatjeffsmith, Jun 04 '18 at 20:29

score 2 · Answer 1 · answered Jun 04 '18 at 17:41

2

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

answered Jun 04 '18 at 17:41

Patrick H

653
6
14

Subtract 14 days from system date

1 Answers1