MONEY_FORMAT (Lakehouse v2)

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  │
└──────────────┘