Title:
Bug 86947:-(Watson Migration Closure)ER: add additional argument to Round so that you can specifiy number of decimals places
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/
Reporter/Name(from Bugbase): John Whish / John Whish (John Whish)
Created: 06/17/2011
Components: General Server
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
ER: add additional argument to Round so that you can specifiy number of decimals places. Also, allow negative values so that you can round to the nearest 10n. Examples:ROUND(123.4545, 2) = 123.45ROUND(123.455, 2) = 123.46ROUND(748.58, -4) = 0ROUND(748.58, -1) = 750.00ROUND(748.58, -2) = 700.00
Method:
Result:
ER: add additional argument to Round so that you can specifiy number of decimals places. Also, allow negative values so that you can round to the nearest 10n. See how the round function works in MS SQL Server: http://msdn.microsoft.com/en-us/library/ms175003.aspx
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3043866
External Customer Info:
External Company:
External Customer Name: John Whish
External Customer Email: 4B9370D7448AB8BF9920157F
External Test Config: 06/17/2011Attachments:
Comments: