SQL>
SELECT Today
,End_Quarter2
,(End_Quarter2 - Today) AS Days_To_Go
FROM (SELECT Trunc(SYSDATE) Today
,To_Date('30.06.2009'
,'DD.MM.YYYY') End_Quarter2
FROM Dual);
TODAY END_QUARTER2 DAYS_TO_GO
----------- ------------ ----------
22.06.2009 30.06.2009 8
SQL>