[sqlite] round and storage class

2007-03-26 Thread Iulian Musat
Hello everybody ! First of all I have to say that I'm a fairly new user of SQLite, so be kind :-) The problem is with the round function: the result have a decimal point even if the second argument is zero (the default): sqlite select round(1.234); 1.0 sqlite select round(1.234,0); 1.0 I'm

Re: [sqlite] round and storage class

2007-03-26 Thread Dennis Cote
Iulian Musat wrote: Hello everybody ! First of all I have to say that I'm a fairly new user of SQLite, so be kind :-) The problem is with the round function: the result have a decimal point even if the second argument is zero (the default): sqlite select round(1.234); 1.0 sqlite select