Oracle的函数：截取和合并
Oracle的函数：截取和合并
Java代码
select to_char(t.create_time,'yyyy-mm-dd')as date_,remark,
substr(t.remark, 1, 4) as yyyy,
substr(t.remark, 5, 2) as dd,
(case
when substr(t.remark, 7, 2) = '00' then
'01'
else
substr(t.remark, 7, 2)
end) as dd
,
(substr(t.remark, 1, 4)||'-'||substr(t.remark, 5, 2)||'-'||
(case
when substr(t.remark, 7, 2) = '00' then
'01'
else
substr(t.remark, 7, 2)
end))as cjd
from temp_xxx t;
Java代码
update temp_xxx t1 set t1.create_time=to_date(
substr(t1.remark, 1, 4)||substr(t1.remark, 5, 2)||
(case
when substr(t1.remark, 7, 2) = '00' then
'01'
else
substr(t1.remark, 7, 2)
end)
,'yyyymmdd'
);
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。