Oracle PeopleSoft

Subtracting Dates

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:

The %DateDiff function returns an integer.

In Oracle you can use the subtraction operator:

Use ROUND() to round to the nearest day or TRUNC() to round down to the number of whole days.

Leave a Reply

Your email address will not be published. Required fields are marked *