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 second in sysdate

sanju_sql_plsqlMay 2 2011 — edited May 2 2011
Dear Gurus,

I want to add seconds i.e. 4 sec in sysdate
example :
If sysdate is '02-May-2011 15:25:12' and if I want to add 40 seconds then output should be '02-May-2011 15:25:52'

Please help in above.

Thanking in Advance
Sanjeev
This post has been answered by Sunny kichloo on May 2 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2011
Added on May 2 2011
2 comments
3,467 views