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
Printable View
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
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.