MONEY_FORMAT
Learn how to use the MONEY_FORMAT string function in PlaidCloud Lakehouse. Formats a number as a currency string with commas and two decimal places.
Formats a number as a currency string with commas and two decimal places.
Analyze Syntax
func.money_format(<num>)
Analyze Examples
func.money_format(1234567.89)
┌────────────────┐
│ '1,234,567.89' │
└────────────────┘
SQL Syntax
MONEY_FORMAT(<num>)
SQL Examples
SELECT MONEY_FORMAT(1234567.89);
┌──────────────┐
│ 1,234,567.89 │
└──────────────┘