Oracle的函数：截取和合并
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'
);
