On 10/6/00 12:19 PM, "Walter Miller" <[EMAIL PROTECTED]> wrote:
> The Oracle8i recordset I'm retrieving includes a few columns which are
> NUMBER(10,0) format which are milliseconds. I would like to divide each by
> 1000 and use the ROUND function to return a result with one decimal place,
> e.g. ROUND(column1/1000, 1) returns 3.1 where column1 == 3080.
>
> This works as expected in SQL*Plus. It returns the results as a number
> formated to one decimal place. ZSQL however returns only an integer.
>
> Any suggestions on how to get the decimal places to show?
Please make sure you're using the latest Oracle DA, as there was a bug in
handling of things that oracle returns as NUMBER(0,0) (which is basically a
floating point, but we interpreted as a numberb ecause the scale was 0).
Chris
--
| Christopher Petrilli Digital Creations
| [EMAIL PROTECTED]Where Zope comes from
___
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )