Hi, It is not the round function, but the calculation (25*75/197). Since all arguments are integers, the result will also an integer (SQL convention). Try: 25.0*75.0/197.0
Kind regards, Robert -----Oorspronkelijk bericht----- From: Hugues Van Landeghem (JIRA) Sent: Tuesday, July 29, 2014 1:50 PM To: [email protected] Subject: [Firebird-devel] [FB-Tracker] Created: (CORE-4502) ROUND internalfunction ROUND internal function ----------------------- Key: CORE-4502 URL: http://tracker.firebirdsql.org/browse/CORE-4502 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.3 Environment: WINDOWS 7 64 bit, Dialect 3 Reporter: Hugues Van Landeghem Hi everybody, I find something strange with round function. SELECT ROUND(9.51) FROM RDB$DATABASE will return 10 SELECT ROUND(25*75/197) FROM RDB$DATABASE will return 9 Why it doesn't return the same value ? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel ------------------------------------------------------------------------------ Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
