set decimal point in SQL
От | Bu, Ning |
---|---|
Тема | set decimal point in SQL |
Дата | |
Msg-id | B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2 обсуждение исходный текст |
Ответы |
Re: set decimal point in SQL
|
Список | pgsql-sql |
<img class="shape" height="0" src="cid:image001.jpg@01C33428.8D51A460" style="display:none;width:0;height:0" v:shapes="_x0000_Mail"v:src="cid:image001.jpg@01C33428.8D51A460" width="0" /><div class="Section1"><p class="MsoNormal"><fontcolor="black" face="sans serif" size="3"><span style="font-size:12.0pt"> </span></font><p class="MsoNormal"><fontcolor="black" face="sans serif" size="3"><span style="font-size:12.0pt"> </span></font><p class="MsoNormal"><b><i><fontcolor="navy" face="Book Antiqua" size="3"><span style="font-size:12.0pt;font-family:"Book Antiqua";mso-bidi-font-family:"BookAntiqua"; color:navy;font-weight:bold;font-style:italic;mso-no-proof:yes">I have a field set up as money and I try to calculate somenumber and put in this field, but the number will be 6 demical point and I want to cut it to only 2-4 decimal point,how can I do it? Thanks</span></font></i></b></div>
В списке pgsql-sql по дате отправления: