oracle截取函数的编写,Oracle开发--日期截取及四舍五入

SQL >select sysdate "Now date",

2Round (sysdate, 'yyyy' ) Round_year,

3 Trunc(sysdate, 'yyyy' ) Trunc_year

4from dual;

Now date ROUND_YEAR TRUNC_YEAR

---------- ---------- ----------

30- 6月-0801- 1月-0801- 1月-08

关于这两个函数可用的格式非常多，但日常应用中用得比较多的基本上就这几个，以Round函数为例：

select Round (sysdate, 'Q' ) Rnd_Q,

Round (sysdate, 'Month' ) Rnd_Month,

Round (sysdate, 'WW' ) Rnd_Week,

Round (sysdate, 'W' ) Rnd_Week_again,

Round (sysdate, 'DDD' ) Rnd_day,

Round (sysdate, 'DD' ) Rnd_day_again,

Round (sysdate, 'DAY' ) Rnd_day_of_week,

Round (sysdate, 'D' ) Rnd_day_of_week_again,

Round (sysdate, 'HH12' ) Rnd_hour_12,

Round (sysdate, 'HH24' ) Rnd_hour_24,

Round (sysdate, 'MI' ) Rnd_minute

from dual