oracle trunc 去除秒,Oracle trunc函数的使用

/***************数字********************/

/*

TRUNC(NUMBER,NUM_DIGITS)

NUMBER 需要截尾取整的数字。

NUM_DIGITS 用于指定取整精度的数字。NUM_DIGITS 的默认值为 0。

TRUNC()函数截取时不进行四舍五入

*/

/****************小数***********************/

SELECT TRUNC(123.458,-4) FROM DUAL; --0

SELECT TRUNC(123.458,-3) FROM DUAL; --0

SELECT TRUNC(123.458,-2) FROM DUAL; --100

SELECT TRUNC(123.458,-1) FROM DUAL; --120

SELECT TRUNC(123.458) FROM DUAL; --123

SELECT TRUNC(123.458,1) FROM DUAL; --123.4

SELECT TRUNC(123.458,2) FROM DUAL; --123.45

SELECT TRUNC(123.458,3) FROM DUAL; --123.458

SELECT TRUNC(123.458,4) FROM DUAL; --123.458

/****************整数***********************/

SELECT TRUNC(123,-4) FROM DUAL; --0

SELECT TRUNC(123,-3) FROM DUAL; --0

SELECT TRUNC(123,-2) FROM DUAL; --100

SELECT TRUNC(123,-1) FROM DUAL; --120

SELECT TRUNC(123) FROM DUAL; --123

SELECT TRUNC(123,1) FROM DUAL; --123

SELECT TRUNC(123,2) FROM DUAL; --123