CREATE TABLE NEWTABLE ( COL1 INTEGER, COL2 VARCHAR(10), COL3 DATE, ADDTIME TIMESTAMP ) 方法一:right(CHAR(COL3),5) SELECT COL1, COL2, right(CHAR(COL3),5)FROM ERPYXUSR.NEWTABLE 方法二:SUBSTR(CHAR(addtime),6) as 调度员完成时间 SELECT COL1, COL2, SUBST...