Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

### ROUND function [Numeric]

Rounds the numeric-expression to the specified integer-expression amount of places after the decimal point.

###### Syntax

ROUND( numeric-expression, integer-expression )

###### Parameters

numeric-expression    The number, passed into the function, to be rounded.

integer-expression    A positive integer specifies the number of significant digits to the right of the decimal point at which to round. A negative expression specifies the number of significant digits to the left of the decimal point at which to round.

###### Remarks

The result of this function is either numeric or double. When there is a numeric result and the integer integer-expression is a negative value, the precision is increased by one.

`SELECT ROUND( 123.234, 1 );`
{"ft_lang_label":"__label__en","ft_lang_prob":0.70436853,"math_prob":0.9280983,"size":881,"snap":"2022-27-2022-33","text_gpt3_token_len":173,"char_repetition_ratio":0.16761687,"word_repetition_ratio":0.12307692,"special_character_ratio":0.20658343,"punctuation_ratio":0.11875,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99108905,"pos_list":[0,1,2],"im_url_duplicate_count":[null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-07-02T12:27:24Z\",\"WARC-Record-ID\":\"<urn:uuid:449911c2-0598-4532-8ece-c032923d1751>\",\"Content-Length\":\"4873\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:3c27db35-707f-42a4-ab68-5ea0aa8665ae>\",\"WARC-Concurrent-To\":\"<urn:uuid:b582eb92-eaba-4d99-ac04-547716ddba64>\",\"WARC-IP-Address\":\"130.214.205.8\",\"WARC-Target-URI\":\"https://dcx.sap.com/1001/en/ulfoen10/fo-round.html\",\"WARC-Payload-Digest\":\"sha1:I2P5XZOQQGRQFENQ6YNEEGOOBG2CHJDE\",\"WARC-Block-Digest\":\"sha1:IQRFFNOTECE3LONRGUMUMD73PPNCBYQY\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-27/CC-MAIN-2022-27_segments_1656104054564.59_warc_CC-MAIN-20220702101738-20220702131738-00542.warc.gz\"}"}