I ran into something perculiar in SSIS today.
It turns out that this does not do a truncate, but it rounds (up or down) to the nearest integer.
I tried searching for an answer, but was not able to find any.
asked Jun 30, 2011 at 12:39 AM in Default
Henrik Staun Poulsen
Only to be completely correct to really truncate (cut off decimal places) from signed numeric value you have to write following expression:
As single floor function returns the largest integer value, that is less then or equal to the value provided.
In case of negative value eg.
answered Jun 30, 2011 at 03:24 AM