oracle 函数 实例

输入时间(date类型)/要返回的年/月/日

create or replace function find_time(time_form   date,timef  varchar2) 
  return varchar2 is
  time_now     varchar2(100);
  time_result  varchar2(100);
  begin
    select to_char(time_form,'yyyy-MM-dd HH24:mm:ss')  into time_now from dual;
    if timef='year' then
       time_result:=SUBSTR( time_now ,1,4);
       end if;

    if timef='month' then
       time_result:=SUBSTR( time_now ,6,2);
        end if;

    if timef='day' then
       time_result:=SUBSTR( time_now ,9,2);
        end if;

    if timef='minute' then
       time_result:=SUBSTR( time_now ,12,8);
        end if;
        return time_result;
    end find_time;

--测试

 select find_time(sysdate,'minute') from dual;