adding date and time

[Ashutosh]

Hi,
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?
Ashutosh

[m1l]

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.