FORMAT()函數(shù)是用來(lái)按以下格式格式化數(shù)字X:###,###,###。##以小數(shù)D截?cái)?。下面的例子演示了FORMAT()函數(shù)的使用和輸出:
SQL>SELECT FORMAT(423423234.65434453,2); +---------------------------------------------------------+ | FORMAT(423423234.65434453,2) | +---------------------------------------------------------+ | 423,423,234.65 | +---------------------------------------------------------+ 1 row in set (0.00 sec)