SQLServer和Oracle的常用函数对比
2007-10-31 12:38:00 阅读42 评论0 312007/10 Oct31
1.绝对值
S:select abs(-1) value
O:select abs(-1) value from dual
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.取整（小）
S:select floor(-1.001) value
O:select floor(-1.001) value from dual