15位身份证号和18位身份证号截取生日

CASE WHEN T1.IDTYPE=01 AND LENGTH(TRIM(T1.IDNO))=15 THEN'19'||SUBSTR(T1.IDNO,7,6)WHEN T1.IDTYPE=01 AND LENGTH(TRIM(T1.IDNO))=18 THEN SUBSTR(T1.IDNO,7,8)ELSE '-01-01'END