Re: [sqlite] sqlite-3.3.4 and extra float decimals

[Will Leshner]

On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello,
>
> When using sqlite-3.3.4 with windows I get the following strange behaviour.
>
> create table Muppet (Kermit float);
> insert into Muppet values (100);
> select * from Muppet;
> 100.0

That's not strange. Kermit is defined to be a FLOAT, so it gets
returned as a FLOAT. Perhaps you wanted it to be returned as an
INTEGER? You could try something like this:

SELECT cast(kermit as INTEGER) FROM Muppet;