Date Function on Redbrick or Oracle

Is the function for getting system date for BRIO operating within
Redbrick DB is:

getDate();

and for Oracle is:

SysDate();

I am trying to run a report (operating in Redbrick DB) which
captures PAST THREE MONTHS. This report has to run EVERY WEEK.

So my logic is to find out TODAY's DATE and MINUS 3 months.

Also, what is the syntax or formula to MINUS 3 months?

sysDate() - 90 ?

please assist.

Thanks.

AntonOracle,

select SYSDATE - Interval '3' Month from dual;

OR

select add_months(sysdate, -3) from dual;|||thanks.

but can I get the current date without using the dual table, if it's on oracle?

how about redbrick?

the db i'm querying on is on redbrick.|||U Can get today date in rebrick using
current_date.

Thanks,
Praveen.|||yep. thanks!