Collections:
FORMAT() - Formatting Number to String
How to convert a number into a string in a given format using the FORMAT() function?
✍: FYIcenter.com
FORMAT(X, D, locale) is a MySQL built-in function that converts a number into a string in a given format according to the rounding rule and the specified locale standard. For example:
SELECT FORMAT(12332.1,4), FORMAT(12332.1, 4, 'de_DE'); -- +-------------------+-----------------------------+ -- | FORMAT(12332.1,4) | FORMAT(12332.1, 4, 'de_DE') | -- +-------------------+-----------------------------+ -- | 12,332.1000 | 12.332,1000 | -- +-------------------+-----------------------------+ SHOW VARIABLES LIKE 'lc_time_names'; -- +---------------+-------+ -- | Variable_name | Value | -- +---------------+-------+ -- | lc_time_names | en_US | -- +---------------+-------+
Reference information of the FORMAT() function:
FORMAT(X, D, locale): str Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. The optional third parameter enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between separators. Arguments, return value and availability: X: Required. The number to be converted. D: Required. The decimal place to round to. locale: Optional. Default is the system locale. int: Return value. The year week combination. Available since MySQL 4.
⇒ FORMAT_BYTES() - Formatting Bytes in Readable Units
⇐ FLOOR() - Flooring a Numeric Value
2023-11-18, 300🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...