mysql varchar to double

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
select sum(paymoney) from (SELECT CAST(ActualMoney as DECIMAL(9,2)) paymoney FROM api_bainaplayresult where date_format(CreateTime,'%Y-%m-%d') = '2013-12-20' and ResultCode=0 and ChannelCode='y0hpb04zr3' and Comefrom='mfwx001') as mymoney
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Loren at January 23, 2014 - 5:41 AM