trunc a decimal number to the X position
Posted: Wed Feb 03, 2010 2:48 pm
Hello Everyone,
I've tried to find it here but without luck, so here is my question,
i want to "trunc" a decimal number up to the 3rd position after the decimal separator, i don't want to round the number.
for example:
i have a decimal number --> 1785.65897
and i want the result to be --> 1785.658
what is the simplest why to accomplish it in Datastage?
thanks,
Datamine
I've tried to find it here but without luck, so here is my question,
i want to "trunc" a decimal number up to the 3rd position after the decimal separator, i don't want to round the number.
for example:
i have a decimal number --> 1785.65897
and i want the result to be --> 1785.658
what is the simplest why to accomplish it in Datastage?
thanks,
Datamine