how to get no of days using oracle date function
727350Jan 5 2010 — edited Jan 5 2010Dear all,
i need different output from this query mentioned below.
suppose i have execute this query.
sql> select add_month(SYSDATE, -1 * 6) finaldate from dual;
it will give the output as
sql>FINALDATE
-----------------
05-JUL-2009 13:46
now i need to get the total no days from the same query that means it should calculate the total no of days from july to current date and give the output.
if you can give any hint.
Regards
Laxman