sqldecimal-point

Find a value after a point or before a point

Here is my query:

Select 23.25 from dual

How can I Select only 23 from this number or 25 from this number. I mean to find the value after a point or before a point i number.

Solution

  • Do you mean that you want FLOOR()?

    SELECT         FLOOR(23.25) FROM dual
SELECT 23.25 - FLOOR(23.25) FROM dual