Round down a numeric

I think you are looking for floor(a * 100) / 100. Quick Test I just noticed that you changed your question 7 hours ago. Then my answer is not doing exactly what you want (as I am assuming by “rounding down” you always want to round toward -Inf). But I have discussed this in first version of … Read more