Skip to Main Content

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!

Round a Timestamp

MoonlightJul 10 2020 — edited Jul 10 2020

Dear,

I have this timestamp :  25/08/2006 12:28:04,999999000

I would like to be : 25/08/2006 12:28:05

So, how can I do that?

Thank you so much in advance.

This post has been answered by mathguy on Jul 10 2020
Jump to Answer
Comments
Post Details
Added on Jul 10 2020
5 comments
2,185 views