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

Thread: Date Calulation (add Hours)

  1. #1
    Join Date
    May 2001
    Posts
    28

    Question

    Can someone help me with the SQL that would calculate what time it would be by adding 15 hours to the time that is now(sysdate)? Thanks.

  2. #2
    Join Date
    Mar 2001
    Posts
    16
    SELECT TO_CHAR(SYSDATE + 15/24, 'DD-MON-YY:HH24:MI') FROM DUAL

  3. #3
    Join Date
    May 2001
    Posts
    28
    That works. Thank you very much for your help!!

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