Answers for "how to round to two decimal places in sql"

sql decimal to 2 places

CAST(MyNumber AS NUMERIC(18,2))

Posted by: Guest on March-22-2021

sql limit decimal places

SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03

Posted by: Guest on April-10-2020

Code answers related to "how to round to two decimal places in sql"