Re: [sqlite] Decimal conversion

[Dennis Cote]

nbiggs wrote:

How do I convert the number 49.991 to just 49.9 in a select statement?
Using the round(weight, 1) returns 50.0.
Is there a truncate function?
 

Nathan,

You can use:

select cast ((field * 10) as integer) / 10.0

If this is something you do a lot of it might make sense to define a 
custom function.

HTH
Dennis Cote