sql - how to add second in oracle timestamp

Question

How can I add seconds with timestamp value in Oracle. I tried this ....

SELECT CURRENT_TIMESTAMP , CURRENT_TIMESTAMP+200 AS addedTime FROM dual

But by this I am getting this

2018-06-04 19:03:01 => 2018-12-21 19:03:01 (after adding 200)

As you can see date is getting added , but I want to add second only...

This SQL running properly in DB2 , can any one suggest me any suitable alternative in Oracle.

Answer 1

You could always use fraction(for Oracle 1 = 1 day):

SELECT CURRENT_TIMESTAMP ,
       CURRENT_TIMESTAMP + 200 *(1/24/60/60) AS addedTime 
FROM dual;
<=>
SELECT CURRENT_TIMESTAMP + 200/86400 FROM dual

DBFiddle Demo

or:

SELECT CURRENT_TIMESTAMP + INTERVAL '200' SECOND FROM dual