Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to add seconds to timestamp

2988654Sep 10 2015 — edited Sep 10 2015

    Hello,

I am trying to add seconds to timestamp but it keep dropping the time component...

SELECT mytime + (duration / 86400) start_time

FROM mytable

The result is something like 01-JUN-15. I need time component.

mytime is timestamp(6) and duration is a number.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2015
Added on Sep 10 2015
3 comments
9,999 views