db2截取字符串函数使用
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,
?? SUBSTR(CHAR(addtime),6) as 调度员完成时间
FROM
??? ERPYXUSR.NEWTABLE
?
?
?
?
?
?截取只显示月日 时分 无秒
?
SELECT
??? COL1,
??? COL2,
??? concat(concat(left(left(SUBSTR(trim(CHAR(addtime)),6),11),5),' '),right(left(SUBSTR(trim(CHAR(addtime)),6),11),5)) as 调度员完成时间
FROM
??? ERPYXUSR.NEWTABLE
?
?
?
