Answers for "sql set number of decimal places"

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

2 decimal places sql.

SELECT ROUND(135.375, 2);

Posted by: Guest on August-11-2021

Code answers related to "sql set number of decimal places"