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!

Convert hh:mm:ss.sss To Integer

mc2112Jun 2 2014 — edited Jun 4 2014

I've been able to search for discussions dealing with converting seconds to hours.minutes.seconds, but none going the other way.

I've recently had the data coming into a table chang from ss.ss (just an integer really)  to the longer format.

Does the CONVERT function allow the conversion of hh:mm:ss.sss to just an integer (ss.ss)?

I can't seem to find this being discussed before.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2014
Added on Jun 2 2014
9 comments
1,217 views