日期转化成大写二〇〇七年十一月二十三日

最新推荐文章于 2020-11-15 23:39:06 发布

joe83004

最新推荐文章于 2020-11-15 23:39:06 发布

阅读量3.2k

点赞数

分类专栏： AJAX

本文链接：https://blog.csdn.net/joe83004/article/details/4161105

版权

AJAX 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

select Substr(NewDate,1,4) ||
       Case when substr(NewDate,5,1) = '-' then '年' else substr(NewDate,5,1) end ||
       Case when substr(NewDate,6,1) = '〇' then '〇' else '十' end ||
       case when SubStr(NewDate,7,1) = '〇' then '月' else SubStr(NewDate,7,1)||'月' end ||
       Case substr(NewDate,9,1) when '〇' then '' when '一' then '十' else substr(NewDate,9,1) || '十' end ||
       case when substr(Newdate,10,1)= '〇' then '日' else SubStr(NewDate,10,1)|| '日' end Newdate
   from (select translate('2007-11-23','0123456789','〇一二三四五六七八九') NewDate from dual)