Convert money type to int

From: "Rich Ryan" <rich(at)usedcars(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Convert money type to int
Date: 2001-12-13 03:36:30
Message-ID: 07b301c18387$5cd52260$1a02a8c0@gateway
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Miguel Gonzalez 2001-12-13 12:52:28 Settings using PuTTy
Previous Message fcanedo 2001-12-12 17:55:54 Re: [GENERAL] shared library

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2001-12-13 04:08:22 Re: [HACKERS] [GENERAL] Using Cursor in PostgreSQL 7.2
Previous Message Adam Fisher 2001-12-13 03:08:29 foreign key creation problem