本文深入探讨了时间trunc函数的使用方法，包括函数简介、示例应用及格式模型说明。
关于时间 trunc 函数的使用。
1. trunc 函数
简介：
The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. The value returned is always of datatype DATE, even if you specify a different datetime datatype for date. If you omit fmt, then date is truncated to the nearest day. Please refer to "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt.
例子：
1. trunc 函数
简介：
The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. The value returned is always of datatype DATE, even if you specify a different datetime datatype for date. If you omit fmt, then date is truncated to the nearest day. Please refer to "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt.
例子：
The following example truncates a date:
SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR')
"New Year" FROM DUAL;
New Year
---------
01-JAN-92
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25380220/viewspace-709186/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/25380220/viewspace-709186/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
