arbeiten mit date unter oracle

[Bernd]

Hallo,

hier ein Auzug aus der Oracle-Doku:

Date Arithmetic
You can add and subtract number constants as well as other dates from dates.
Oracle interprets number constants in arithmetic date expressions as numbers of
days. For example, SYSDATE + 1 is tomorrow. SYSDATE - 7 is one week ago.
SYSDATE + (10/1440) is ten minutes from now. Subtracting the hiredate column
of the emp table from SYSDATE returns the number of days since each employee
was hired. You cannot multiply or divide DATE values.

Also probier mal:

Beispiel:

select table_name, last_analyzed from dba_tables
   where last_analyzed < sysdate - 7;

Gruss

Bernd