Oracle获取日期的两种方法

----两种方法分段获取日期
----用extract

create table test1 as 
select 
extract (year from systimestamp ) as "year",
extract (month from systimestamp ) as "month",
extract (day from systimestamp ) as "day",
extract (hour from systimestamp ) as "hour",  ---获得的时间不是24小时制的
extract (hour from timestamp'2012-12-10 14:02:01' ) as "hour2", ----获得指定日期的小时
extract (minute from systimestamp ) as "minute",
extract (second from systimestamp ) as "second"
from dual;

----用to_char
create table test2 as

select 
to_char(sysdate,'yyyy') as yyyy1 ,
to_char(sysdate,'mm') as mm1 ,
to_char(sysdate,'dd') as dd1 ,
to_char(sysdate,'hh24') as hour1 ,
to_char(sysdate,'mi') as minute1 ,
to_char(sysdate,'ss') as second1 
from dual;

select * from test1;
select * from test2;