Minus dates from sysdate

[kloner]

Hi all,

I guess this is a simple thing to do, but I am having trouble.

I want to do the following in a SQL statement in Oracle.

1. Select * from tbl_blah where
AUDIT_TIMESTAMP < (sysdate - x days)


2. Select * from tbl_blah where
AUDIT_TIMESTAMP < (sysdate - x months)


3. Select * from tbl_blah where
AUDIT_TIMESTAMP < (sysdate - x years)


Any help appreciated.

Regards,

kloner

 

[jimbopalmer]

1. Select * from tbl_blah where
AUDIT_TIMESTAMP < trunc(sysdate - x_days)

2. Select * from tbl_blah where
AUDIT_TIMESTAMP < trunc(sysdate - x_months * 30)

3. Select * from tbl_blah where
AUDIT_TIMESTAMP < trunc(sysdate - x_years * 365) love everyone til they prove otherwise, sadly some prove otherwise SO quickly

 

[lewisp]

1. Select * from tbl_blah where
AUDIT_TIMESTAMP < trunc(sysdate - x_days)

2. Select * from tbl_blah where
AUDIT_TIMESTAMP < add_months(trunc(sysdate,-x_months))

3. Select * from tbl_blah where
AUDIT_TIMESTAMP < add_months(trunc(sysdate,(-x_months * 12))