if l_wa_field-value eq 'ZFIRST_REQ_DATE'.
clear lv_length.
lv_length = strlen( l_wa_excel-value ).
case lv_length.
when 8.
concatenate l_wa_excel-value+4(4) '0' l_wa_excel-value+0(1) '0' l_wa_excel-value+2(1)
into l_wa_excel-value.
when 9.
search l_wa_excel-value for '/'.
if sy-subrc eq 0.
case sy-fdpos.
when 1.
concatenate l_wa_excel-value+5(4) '0' l_wa_excel-value+0(1) l_wa_excel-value+2(2)
into l_wa_excel-value.
when 2.
concatenate l_wa_excel-value+5(4) l_wa_excel-value+0(2) '0' l_wa_excel-value+3(1)
into l_wa_excel-value.
when others.
endcase.
endif.
when 10.
concatenate l_wa_excel-value+6(4) l_wa_excel-value+0(2) l_wa_excel-value+3(2)
into l_wa_excel-value.
when others.
endcase.
endif.
相关文章
- ORACLE修改默认时间格式的四种方式:NLS_DATE_FORMAT
- mysql之时间截取函数DATE_FORMAT
- Convert excel format can try specifying the ‘excelType‘ yourself
- 记一次使用EasyExcel出现Convert excel format can try specifying the ‘excelType‘ yourself
- 【Java】【SQL】DATE_FORMAT函数详解
- Excel Old format or invalid type library 错误原因
- mysql怎么更改日期的格式_如何在MySQL中使用DATE_FORMAT更改日期格式?
- mysql 数据库时间类型 datetime 数据在页面上显示一串数字, 用函数date_format( )转换格式 ;
- jxl 读写Excel实例(設置cell format 格式)
- mysql 时间戳 日期转换 DATE_FORMAT,FROM_UNIXTIME,UNIX_TIME等