v.23.3New Feature

Added toDecimalString Function for Fixed Precision Number Conversion

Official CH changelog text
Added toDecimalString function allowing to convert numbers to string with fixed precision. #47838 (Andrey Zvonov).
Added the toDecimalString function that converts numeric values to strings with fixed decimal precision.

Why it matters

This feature addresses the need for precise control over the string representation of numeric values, enabling users to convert numbers into strings formatted with a specified number of decimal places. It enhances readability and formatting consistency in query results.

How to use it

Use the toDecimalString function by passing a numeric value and the desired precision as arguments. For example:

sql<br>SELECT toDecimalString(123.4567, 2)<br>FROM table<br>
This returns the string representation of the number with 2 decimal places.

Related resources

PreviousNext