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 obtain the integer and fractional parts of a number ?

783956Jul 23 2010 — edited Jul 23 2010

Good morning,

given the value:

5433.43567

I'd like to know if there is a function such that

f(5433.43567) = 5433

and another such that

f2(5433.43567) = 0.43567

Without any rounding, truncation or other "special effects" ;). I can synthesize those functions using to_char, string manipulation and to_number but I'd like to make sure that I didn't miss a simpler way or, a combination of those functions that is really simple (the stuff I've come up with is hardly simple :( )

Thank you for your help,

John.

This post has been answered by 731280 on Jul 23 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2010

Added on Jul 23 2010

8 comments

23,158 views