Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: 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.

    Anton

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Oracle,

    select SYSDATE - Interval '3' Month from dual;

    OR

    select add_months(sysdate, -3) from dual;
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jan 2004
    Posts
    7
    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.

  4. #4
    Join Date
    Feb 2004
    Posts
    1

    Arrow for current date in redbrick

    U Can get today date in rebrick using
    current_date.


    Thanks,
    Praveen.

  5. #5
    Join Date
    Jan 2004
    Posts
    7
    yep. thanks!

  6. #6
    Join Date
    Jan 2008
    Posts
    8
    I have similar requirment but inmycase i just need month and year in the format MMYYYY. that is for curent date - 3month

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •