Subject | Rounding function? |
---|---|
Author | Joe Martinez |
Post date | 2003-02-05T06:15:08Z |
Does FB 1.0 have a rounding function?
I want to issue a command that sets a particular field as the value of
another field, multiplied by 2.3, but I want the result rounded to 2
decimal places.
So, it would be something like:
update mytable set field1 = ROUND(field2 * 2.3,2)
Does such a function exist in FB 1.0, and if so, what is the exact syntax?
Thanks,
Joe
I want to issue a command that sets a particular field as the value of
another field, multiplied by 2.3, but I want the result rounded to 2
decimal places.
So, it would be something like:
update mytable set field1 = ROUND(field2 * 2.3,2)
Does such a function exist in FB 1.0, and if so, what is the exact syntax?
Thanks,
Joe