If you want to find the difference in dates between now and some date in the past/future then you can use the following query using peoplesoft meta-SQL:
|
1 |
SELECT %DateDiff(%DateIn('2009-12-17'), %CurrentDateIn) FROM PS_INSTALLATION |
The %DateDiff function returns an integer.
In Oracle you can use the subtraction operator:
|
1 |
SELECT ROUND(SYSDATE - TO_DATE('2009-12-17','yyyy-mm-dd')) FROM DUAL |
Use ROUND() to round to the nearest day or TRUNC() to round down to the number of whole days.