Quote Originally Posted by LKBrwn_DBA
You may also need TRUNC() on your dates:
Code:
where TRUNC(date_col01) = last_day(add_months(trunc(sysdate),-3));
Looks like he is getting results when running the query with literal value. In case date values are not truncated in the table I would go for >= and < combination instead to avoid type conversion.

Sergey