Subject | Re: [firebird-support] Miscalculation of floating points in Firebird |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2018-01-26T18:05:08Z |
26.01.2018 16:17, Salim Naufal s.naufal@... [firebird-support] wrote:
SQL standard rules say that result of calculations on decimals is a decimal of appropriate
precision.
--
WBR, SD.
> I am not familiar with the details of the SQL standard, is this the proper was to roundYes. In your first examples you don't use floating point numbers, but exact decimals.
> and calculate numeric values in SQL?
SQL standard rules say that result of calculations on decimals is a decimal of appropriate
precision.
--
WBR, SD.