[GIS] Definition query that returns based on date in arcgis

Question

I was wondering if anyone knew how to build a definition query in Arcmap 10.0 that returns only features that are f.e. only 7 days old.
I have a SDE geodatabase with polygons, each with a "date"-field (format yyy-mm-dd). I would like to select these features based on their age:

Output 1 ; Last 7 days

Output 2 ; Last 14 days

Output 3 ; Last 30 days

Output 4 ; Last year

….

Thanks in advance

Answer 1

This works on an SDE/Oracle database - select the dates within the last year you can do something like this:

ACQUIREDATE > ADD_MONTHS(SYSDATE, -12)

or last 7 days

ACQUIREDATE > SYSDATE - 7