remove $ from money field

From: Robby Russell <rrussell(at)commandprompt(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: remove $ from money field
Date: 2003-08-09 00:04:40
Message-ID: 3F343A98.5070404@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Should be a simple question.

When selecting a field that is of type money, how can I remove the $
when selected?

example: $10.00 would return as 10.00

-Robby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message culley harrelson 2003-08-09 00:21:45 Re: 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD
Previous Message Tom Lane 2003-08-08 23:08:54 Re: Empty Output? How Do I Determine the Character?