Getting a date range for the Previous Month programatically

[LeonelSanchezJr]

How can I get a date range for the previous month?

Example:

I have a report that needs to run on the 10th day of each month, but I need a START_DATE and an END_DATE returned via PL/SQL.


Thanks,

Leo ;-)

 

[SantaMufasa]

Leonel,

Didn't we just do something similar with you last Saturday? Here is a way to do what you want in PL/SQL:

DECLARE
   START_DATE   DATE := trunc(add_months(sysdate,-1),'MM');
   END_DATE     DATE := Last_Day(Add_Months(SYSDATE,-1));
BEGIN
...
END;
/

Let us know if this resolves your need.

Mufasa
(aka Dave of Sandy, Utah, USA @ 19:20 (13Aug04) UTC (aka "GMT" and "Zulu"), 12:20 (13Aug04) Mountain Time)