Postgres Pro
Downloads
Home   >   mailing lists

remove $ from money field - Mailing list pgsql-general

From Robby Russell
Subject remove $ from money field
Date
Msg-id 3F343A98.5070404@commandprompt.com
Whole thread Raw
Responses Re: remove $ from money field  (Arguile <arguile@lucentstudios.com>)
Re: remove $ from money field  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: remove $ from money field  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Empty Output? How Do I Determine the Character?
Next
From: culley harrelson
Date:
Subject: Re: 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD