2012-02-08 WPF MySQL CAST 索引サイト Wpf-TraceB-1100 MySQL 数値処理の小技 小数点以下がうまく処理されないため 0.00 を演算させて対応 string w_SQL = null; w_SQL = "select TraceN"; w_SQL += ",cast(Juryo_0 as signed) - 0.00 as Juuryo"; w_SQL += ",SrDate"; w_SQL += " from tb_TraceA";