Hiya, am I misinterpreting the names of the functions, or are TO_INTEGER() and TO_NUMBER() in USoft 10.1+ reversed?
For example:
select to_integer('1.25');
select to_number('1.25');
select to_number('1.55');
gives:
1.25
1
2
I would expect TO_INTEGER() to return a (rounded?) integer, and TO_NUMBER() not to return an integer?