Equivalent of Money in MySQL

Asked Mar 16 '17 at 19:02

Active Mar 16 '17 at 20:26

Viewed 1,160 times

How do I convert the following SQL statement into MySQL. Is there a equivalent for money in MySQL ?

 DECLARE v_min_msrp int;
  DECLARE  v_avg_msrp int;
  DECLARE v_max_msrp int;

  SELECT 
    Min(Convert(money, Ifnull(msrp, 0))), 
    Avg(Convert(money, Ifnull(msrp, 0))),
    Max(Convert(money, Ifnull(msrp, 0))) INTO v_min_msrp, v_avg_msrp, v_max_msrp
  FROM imported_data_feed

edited Mar 16 '17 at 20:26

Martin

22,212
11
70
132

asked Mar 16 '17 at 19:02

Sravsk

Please do not use tags that do not apply to your question. – John Conde Mar 16 '17 at 19:03
3

Possible duplicate of [Best data type to store money values in MySQL](http://stackoverflow.com/questions/13030368/best-data-type-to-store-money-values-in-mysql) – Gonzalo.- Mar 16 '17 at 19:05
2

"Money" is roughly equivalent to DECIMAL(19,4) ... which is the same as NUMERIC(19,4). – pmbAustin Mar 16 '17 at 19:07

Equivalent of Money in MySQL

0 Answers0