DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Need Help on Query

  1. #1
    Join Date
    Jul 2003
    Posts
    53

    Need Help on Query

    Hi all,

    I need to return the date by taking the maximum date and subtracting 3 months before that date
    For ge if the maximum date is 31/12/2003 i need to get the that date which is beyond 3 months of this date

    Thanks all
    Anu
    anu

  2. #2
    Join Date
    Jul 2002
    Location
    Slovenia
    Posts
    42
    SELECT TO_DATE('31.12.2003','dd.mm.yyyy') date_orig,
    ADD_MONTHS (TO_DATE('31.12.2003','dd.mm.yyyy'), -3) date_3_months_before
    FROM dual
    Andrej

  3. #3
    Join Date
    Jul 2003
    Posts
    53
    Thanks a lot
    anu

Posting Permissions

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


Click Here to Expand Forum to Full Width