1. TO_CHAR函数:
TO_CHAR 函数用于将数字转换为字符串,并可以指定格式。例如:
SELECT TO_CHAR(12345.6789, '99999.9999') AS result;
这将返回结果:
SELECT TO_CHAR(12345.6789, '99999.9999') AS result;
SELECT CAST(12345 AS VARCHAR) AS result;
SELECT CONVERT(VARCHAR, 12345) AS result;
SELECT CONCAT('The number is: ', 12345) AS result;