Tuesday, 15 April 2014

mysql - Having trouble converting my decimal data type to just 2 decimal places -



mysql - Having trouble converting my decimal data type to just 2 decimal places -

need help here. i'm trying update column in 1 of tables take spend amount 1 column , split 0.85 , display @ 2 decimal places. have tried round function , using cast function list field decimal in i've tried (38,2), (30,2), etc. , none work. here's re-create of i'm trying :

(cast(netmediaspend decimal (38,2)))/.85

and after run , @ info still see value stored :

13712.941176

how display 2 decimals of 13712.94 ?

cast(netmediaspend / .85 decimal(38,2))

mysql

No comments:

Post a Comment