sysdate+5??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: sysdate+5??

  1. #1
    Join Date
    Feb 2001
    Posts
    51

    what does a sysdate+5 or anynumber mean?


    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Oracle dates are stored as the number of days since some base date (I forget when). The integer part of the date represents days. Therefore, any date + 5 means add 5 days to that date.

    - Chris

  3. #3
    Join Date
    Feb 2001
    Posts
    51

    cool

    thats all I needed to know, thanks..

    why is it so hard to me to search for something simple as this? arghhhh..

    ****, the burgers are burning..

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is how you check:

    SQL> select sysdate+5 from dual;

    SYSDATE+5
    =========
    24-APR-01


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you have a chance to try this? Its Fun!!


    select sysdate + interval '100' month(3) from dual;


    It is pretty

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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