Rounding

From: "Chris Boget" <chris(at)wild(dot)net>
To: "PGSql Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Rounding
Date: 2003-10-03 15:26:11
Message-ID: 010201c389c2$b5ca7170$8c01a8c0@ENTROPY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a way, internal in PG, that you can round to the
nearest half decimal (rounded up or down)? ie, I want to
round 97.37 to 97.5 or 97.81 to 98.
The closest thing I could see in the docs would take the
97.33 turning it into 97.4 and 97.81 to 97.8. Is there some-
thing I am missing?

thnx,
Chris

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-10-03 16:24:08 Re: Rounding
Previous Message Menke, Kurt 2003-10-03 14:55:44 importing data automatically