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!

Oracle date function to add one second

507846Apr 21 2006 — edited Apr 21 2006
how to add one second to the date, example, SYSDATE+1 will add one day to current day, but how to add one second to the current time. for example, the current date is "2006-4-21 12:01:12", and I want to add 1 second to the current time, and the result will be "2006-4-21 12:01:13", how to achieve it？？
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2006
Added on Apr 21 2006
5 comments
47,123 views