Brent Baisley wrote:


I would agree, rtfm is a good choice in this regard but the wrong rtfm. This is something that should be done IN the database not in PHP. If you are using PostgreSQL you can do this:

select column::numeric(10,2) from foo;


Joshua D. Drake

On Nov 16, 2004, at 3:38 PM, Chris Payne wrote:

Hi there everyone,

Just a quick question, I’m having to calculate some values from an existing
database, but on some of the results I get (For example)


How can I limit the result to only 2 digits after the decimal point with



--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ( Version: 6.0.797 / Virus Database: 541 - Release Date: 11/15/2004

Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] -
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to