Convert money type to int - Mailing list pgsql-general

From Rich Ryan
Subject Convert money type to int
Date
Msg-id 07b301c18387$5cd52260$1a02a8c0@gateway
Whole thread Raw
In response to How to get database schema without pg_dump?  ("Boban Acimovic" <acim@mbl.is>)
List pgsql-general
There are some instances where I want to display a column I defined as type
money, without the $ sign and truncate the cents. Is there an easy way to do
this? Some kind of built-in function? I tried searching the mailing list
archives on the web site, but it was broken.
Thanks,
Rich



pgsql-general by date:

Previous
From: "Rich Ryan"
Date:
Subject: Money reformatting
Next
From: Timmy 鄧添喜
Date:
Subject: Can I call unix/linux commands within plsql?