clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3799348 fiddles created (41677 in the last week).

with t(x) as (select value(v) from table(sys.odcinumberlist(1.1,-1.1,500.4,-283.5,50,-50))v) select x-mod(x,1)from t /
X-MOD(X,1)
1
-1
500
-283
50
-50
 hidden batch(es)