String queryString = "SELECT c.couponname, c.couponfee, c.pic1_path,date_format(c.endtime,'%Y-%c-%d') as endTimeFROM couponpublish c,couponpool s WHERE s.pubid=c.pubid AND s.owner='"+userId+"' ";
怎么把sql查到的couponfee除以100显示??
couponfee/100,注意数据类型。
String queryString = "SELECT c.couponname, c.couponfee, c.pic1_path,date_format(c.endtime,'%Y-%c-%d') as endTimeFROM couponpublish c,couponpool s WHERE s.pubid=c.pubid AND s.owner='"+userId+"' ";
怎么把sql查到的couponfee除以100显示??
couponfee/100,注意数据类型。