oracle的获取年月日时间，获取5年前日期

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