oracle 时间差为‘年月日’

最新推荐文章于 2024-06-14 09:38:45 发布

jzbgjsy

最新推荐文章于 2024-06-14 09:38:45 发布

阅读量308

点赞数

分类专栏：数据库文章标签： Oracle

本文链接：https://blog.csdn.net/jzbgjsy/article/details/83767041

版权

数据库专栏收录该内容

10 篇文章 0 订阅

订阅专栏

function getTime_Difference(pBeginTime in date) return String is
    vTime varchar2(50);
begin
    select years || '年' ||
       months || '月' ||
       abs(
        trunc(
         newer_date-
         add_months(older_date,years*12+months )
        )
       ) || '天' into vTime
    from (
      select trunc(months_between(newer_date, older_date )/12) YEARS,
             mod(trunc(months_between(newer_date, older_date )),12 ) MONTHS,
             newer_date,
             older_date
      from(
           select pBeginTime older_date,
                  sysdate newer_date
           from dual
      )
    );
return vTime;
end;