Help formatting a number to two decimal places

[Mike Bishop]

When i run the statement below i am getting a number of xxx.xxxx can anyone help me change this to two DP?

(SELECT sum(oht_net) FROM order_header_total
JOIN order_header ON oh_id = oht_oh_id
WHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))

[rproffitt]

I'm thinking the TRIM SQL commands. Oh, yeah, seems a well worn topic. Pick from https://www.google.com/search?q=sql+display+to+2+digits

[Vijay_32]

You can use the TRUNCATE command.

http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_truncate

For more tutorial:
https://hackr.io/tutorials/learn-mysql