MySQL Format Money/Currency with Dollar Sign; Get Total for Month
Format the mysql select with a dollar sign and two decimal places.
SELECT
CONCAT('$', FORMAT(SUM(`invoice_total`), 2)) AS month_total
FROM
`invoices`
WHERE
`invoices`.`timestamp` > DATE_SUB('2009-02-01', INTERVAL 1 DAY) AND
`invoices`.`timestamp` < DATE_ADD(LAST_DAY('2009-02-01'), INTERVAL 1 DAY)
LIMIT
1
1 comment
Thanks so much I've been trying format the output for hours
Leave a Reply