TO_STRING
Description
Converts the specified value into an unformatted text string.
Syntax
TO_STRING(value) -> String
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| value | Object | Yes | The value to convert. |
Examples
TO_STRING(0.25)
-- Returns "0.25".TO_STRING(NOW())
-- Returns the current date and time as a string.Tips
The returned text is unformatted; it does not include currency symbols, percent signs, or commas.
Values are not locale-sensitive (e.g., 24.42 EUR becomes "24.42").
Dates are returned as yyyy-MM-dd.
Datetime values are returned as yyyy-MM-dd HH:mm:ss.