I have a script that does a;

select * from ssrecords_exp

However when this is done the amount filed is
retrieved with four decimal places instead of
two (as in the database).

Is there a way to default the number of decimal places
or would I have to loop through the rows and convert each
to 2 decimal places.

Thanks,

Leslie G. B.

How do you know it is 4 not 2 and not 6?

As far as I know all decimal datatypes are represented as double values which means values in -1e308..1e308 range with up to 18 digitats after decimal point.

By the way, you can also use "select round(mycolumn, 2) as mycolumn from ssrecords_exp" to round the value to 2 decimal digits after the decimal point.

: I have a script that does a;

: select * from ssrecords_exp

: However when this is done the amount filed is
: retrieved with four decimal places instead of
: two (as in the database).

: Is there a way to default the number of decimal places
: or would I have to loop through the rows and convert each
: to 2 decimal places.

: Thanks,

: Leslie G. B.