Converting money types.
От
Craig Anderson
Тема
Converting money types.
Дата
Msg-id
0104A6DCB4B2D2119660009027BC64510977B3@hpmail.netstatresources.com
Список
Hello, I have the following statement... select sum(p.priprice * o.quantity) as total from products p, ordertemp o where o.orderid='xxxx' and o.itemid=p.itemid; This statement returns something like $x,xxx.xx. The column p.priprice is of type money and o.quantity is of type int4. Is there any way to modify that statement to return something like xxxx.xx? Craig Anderson Director of Internet Services Netstat Resources, LLC.
В списке pgsql-general по дате отправления