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