[sqlite] Decimal conversion

[nbiggs]

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 Biggs