sql截取字符串后面四位时间:2024-03-03 20:41:14 方法1: select substr(\'123456789\',length(\'123456789\')-6+1,6) from dual; 方法2: SELECT name, RIGHT(certid,4) as certid FROM mjsxd_newuser_day