I'm doing some work in Oracle on date ranges, and have a calendar table with Activity_date. I'd like to calculate the "relative week no." from this, but I'm not sure of the functions to use...
In MS SQL it was just easy to use datediff, but there is not such function in Oracle, as the dates are stored as numbers....
Anyone point me in the right direction