decode(wt_cgwtd.cgwcsj,NULL,'', substr(wt_cgwtd.cgwcsj, 0, 4) || '年' || substr(wt_cgwtd.cgwcsj, 5, 2) ||'月'||substr(wt_cgwtd.cgwcsj, 7, 2) || '日') cgwcsj
oracle数据库Long时间类型得到年月日类型
于 2020-04-20 19:47:33 首次发布
decode(wt_cgwtd.cgwcsj,NULL,'', substr(wt_cgwtd.cgwcsj, 0, 4) || '年' || substr(wt_cgwtd.cgwcsj, 5, 2) ||'月'||substr(wt_cgwtd.cgwcsj, 7, 2) || '日') cgwcsj