2021-12-28 Oracle 函数 字符串百分比格式化 1to_char(68.5, 'fm990D00') 截取 1to_char(to_date(substr(idno, 7, 4) || '-' || substr(idno, 11, 2) || '-' || substr(idno, 13, 2), 'yyyy-mm-dd'), 'yyyy-mm-dd') 参考 Format Models Newer Windows Older IrfanView