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

Thread: adding date and time

  1. #1
    Join Date
    Nov 2000


    In a stored procedure, I am selecting a date from the table, I want to add some time(say, 3000 seconds) and update the same table. I am getting compilation error when I try time I try to do it.
    Can somebody help me out with this?

  2. #2
    Join Date
    Oct 2000
    Not seeing the procedure, all I can think is that you're not adding part of a day onto the date. For example, if you wanted to add 3000 seconds to SYSDATE, you would put

    select sysdate + (3000/86400) from dual

    because there are 86400 seconds in a day.

    Hope this is of use.

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