[Zope] ZSQL returns integer only
wmiller@mediaone.net
wmiller@mediaone.net
Fri, 06 Oct 2000 15:43:51 -0000
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).
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?