Approximation
-
i made a aql statement :
"select sum(fatrtot)reglz from reglz where fatrdate between '" + DateTimePicker1.Value + "'and'" + DateTimePicker2.Value + "'"and it's working well but there is sometimes gives me this number 10.233333333 how can i approximate it to nearest 10 or 100 plz tell me urgent thanks -
i made a aql statement :
"select sum(fatrtot)reglz from reglz where fatrdate between '" + DateTimePicker1.Value + "'and'" + DateTimePicker2.Value + "'"and it's working well but there is sometimes gives me this number 10.233333333 how can i approximate it to nearest 10 or 100 plz tell me urgent thanksFrom http://www.w3schools.com/sql/sql_functions.asp[^]: ROUND(c,decimals) Rounds a numeric field to the number of decimals specified :)
Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }
-
From http://www.w3schools.com/sql/sql_functions.asp[^]: ROUND(c,decimals) Rounds a numeric field to the number of decimals specified :)
Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }
-
Then show the SQL statement and elaborate on the outcome :)
Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }
-
i made a aql statement :
"select sum(fatrtot)reglz from reglz where fatrdate between '" + DateTimePicker1.Value + "'and'" + DateTimePicker2.Value + "'"and it's working well but there is sometimes gives me this number 10.233333333 how can i approximate it to nearest 10 or 100 plz tell me urgent thanksWe have a SQL forum, you know. The round function does obviously help you, because you can round off the number.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )