oracle相關函數
1.取整(大)? select ceil(-1.5) value from dual
2.取整(小) select floor(-1.5) value from dual
3.取整(截取) select trunc(-1.5) value from dual???????
4.取整(舍入)???? select round(-1.5) value from dual
2.取整(小) select floor(-1.5) value from dual
3.取整(截取) select trunc(-1.5) value from dual???????
4.取整(舍入)???? select round(-1.5) value from dual
posted on 2009-12-22 15:27 tobyxiong 閱讀(204) 評論(0) 編輯 收藏 所屬分類: DATABASES