The TRUNC function Converts a date to the date at midnight
So,
select field_name from your_table
where ActivateDate >= trunc(last_day(add_months(CURRENT_DATE,-2))+1) and ActivateDate < trunc(last_day(add_months(CURRENT_DATE,-1))+1);
good luck !!
Results 1 to 5 of 5
Thread: (Oracle) Data between 2 datesThreaded View
|
|
|