oracle的获取年月日时间
-
正常获取时间
select sysdate from dual;-- 当前时间
select to_char(sysdate,‘YYYY’) from dual; --获取年份 -
另类方法:extract函数
select extract(year from systimestamp) year
,extract(month from systimestamp) month
,extract(day from systimestamp) day
,extract(minute from systimestamp) minute
,extract(second from systimestamp) second
,extract(timezone_hour from systimestamp) th
,extract(timezone_minute from systimestamp) tm
,extract(timezone_region from systimestamp) tr
,extract(timezone_abbr from systimestamp) ta
from dual -
获取5年以前的时间
select extract(year from sysdate)-5 from dual