Made In China Talk  

Go Back   Made In China Talk > E-Commerce > E-Commerce > Internet Marketing
Directory Register FAQ Members List Calendar Mark Forums Read 中文

Help formatting a number to two decimal places

Thread Tools Display Modes
Old 07-14-2018, 12:10 PM
click click is offline
Senior Member
Join Date: Dec 2008
Posts: 80,089
Feedback: (0)
Default Help formatting a number to two decimal places

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_totalJOIN order_header ON oh_id = oht_oh_idWHERE oh_cd_id = cd_id AND oh_sot_id = 1 AND DATEPART(yyyy, oh_datetime) = (SELECT DATEPART(yyyy, GETDATE()) -1))
Pay Per Click Forum
Made In China Talk
Pay-Per-Click Advertising
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

| Business Forum | Toronto Chinese

All times are GMT +9. The time now is 11:59 PM.

All rights reserved. Copyright © 2007 Made In China Talk