codeWarrior wrote:
If it is a numeric data column -- you probably want to use the "round"
function:
SELECT round(1200.01, 3);
SELECT round(12.009, 2);
Interesting. I had tried that. After your message I tried again and
encountered this interesting anomaly: while the ROUND function used in a
query run in the SQL window of PgAdmin III does in fact force output of
trailing zero decimal digits to the extent specified, i.e.,
SELECT
project_number,
labor_hours,
TO_CHAR(labor_hours, '999.999'),
ROUND(labor_hours,3)
FROM time_data
LIMIT 5
"05-08",1974.0000," ###.###",1974.000
"05-100",10810.5000," ###.###",10810.500
"05-125",285.0000," 285.000",285.000
"05-150",404.5000," 404.500",404.500
"05-200",44.0000," 44.000",44.000
Running the same query though a TQuery dataset object in Borland Delphi
using the BDE truncates the trailing zeros from ROUND:
000-05-08 1974 ###.### 1974
000-05-100 10810.5 ###.### 10810.5
000-05-125 285 285.000 285
000-05-150 404.5 404.500 404.5
000-05-200 44 44.000 44
That is why I didn't realize ROUND was an option, but for me it still is
not since the report is produced by a Delphi application. I suppose I
can accomplish this formatting programmatically within the Delphi
application, but I was hoping to have the data base do it directly.
Thanks,
Berend Tober
"Berend Tober" <btober@xxxxxxxxxxxxxxxx> wrote in message
news:4379F997.6050703@xxxxxxxxxxxxxxxxxxx
Say I want to format calculated numeric output to uniformly have a
specific number of decimal places,
...
begin:vcard
fn:Berend Tober
n:Tober;Berend
org:Seaworthy Systems, Inc.
adr:;;22 Main Street;Centerbrook;CT;06409;USA
email;internet:btober@xxxxxxxxxxxxxxxx
tel;work:860-767-9061
url:http://www.seaworthysys.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
