摘要： 1.绝对值SELECT ABS(-1) VALUE SELECT ABS(FLevel) VALUE FROM T_Item(从表或试图里取,FLevel是数值类型的)2.取整(大)SELECT CEILING(-1.0003) VALUESELECT CEILING(FLevel) VALUE FROM T_Item3.取整(小)SELECT FLOOR(-1.002) VALUESELECT FLOOR(字段) VALUE FROM 表4.取整(截取)SELECT CAST(-1.222 AS INT) VALUESELECT cast(FStartDate AS VARCHAR(6)) 阅读全文