sql for difference between 2 dates

[gandolf989]

Originally posted by svk
Sample :
SQL> create table dt (d date);

Table created.

SQL> insert into dt select sysdate-rownum from dba_tables where rownum<101;

100 rows created.

SQL> commit;

Commit complete.

SQL> select max(d)-(sysdate+10) from dt;

MAX(D)-(SYSDATE+10)
-------------------
-11.000162

Whether or not your test is valid depends on whether "current_date" is a variable storing the sysdate or if it a column in the table period.

[svk]

Sure...I agree. I guess I assumed too much when I replaced "current_date" by "sysdate".