Skip to main content

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?

Be the first to reply!

Reply