将总值格式化为2位小数的货币 [英] Format the total value to a currency with 2 decimal places

问题描述

一个相当简单的问题.我必须写一个查询来查找产品库存的总价值.将此金额显示为货币，保留小数点后两位.

A rather simple question. I have to write a query to find the total value of the product inventory. Display this amount as currency with 2 decimal places.

我知道如何轻松获得总值，并且知道TO_CHAR的用法，但是当我尝试使用TO_CHAR时，会出现FROM错误.

I know how to get the total value easy enough, and I know of the TO_CHAR use, however when I attempt it I get a FROM error.

SELECT SUM(PROD_QOH * PROD_PRICE) AS TotalValue 
FROM BOFF.LGPRODUCT;

结果是360307.79.

The outcome is 360307.79.

我希望它显示$ 360,307.79

I'd like for it to display $360,307.79

FORMAT将是无效的标识符.必须使用TO_CHAR

FORMAT will be an invalid identifier. Have to use TO_CHAR

推荐答案

没关系，我自己搞定.

SELECT TO_CHAR(SUM(PROD_QOH * PROD_PRICE), '$999,999.99') AS TotalValue
FROM BOFF.LGPRODUCT;

这篇关于将总值格式化为2位小数的货币的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！