Select from python is retrieving wrong form

Asked Nov 11 '16 at 21:57

Active Nov 12 '16 at 08:11

Viewed 28 times

I'm working with the Firebird database, and I would like to know how to fix a format from an SELECT query. The SELECT query is returning this from the isql

           NU_INSCRICAO
=======================

      4228949000102.000

But in my software, is returning:

4.2289490001e+012

I actually don't understand what the +012 means, also.

edited Nov 12 '16 at 08:11

Mark Rotteveel

100,966
191
140
197

asked Nov 11 '16 at 21:57

In your software, it is returning in exponential form. +012 indicates how many digits it moved the decimal from its original position. – r0xette Nov 11 '16 at 22:03
In other words `4.2289490001*10^12` – Andre Nov 11 '16 at 22:06
It is the same value, it is just displayed differently by Python, see the link in my previous comment how to display it differently. – Mark Rotteveel Nov 12 '16 at 08:12

Select from python is retrieving wrong form

0 Answers0