--TIMESTAMP_FORMAT to_date
db2 "
WITH temp1 (ts1) AS
(VALUES ('1999-12-31 23:59:59') , ('2002-10-30 11:22:33')
)
SELECT ts1 ,to_date(ts1,'YYYY-MM-DD HH24:MI:SS') AS ts2
FROM temp1
ORDER BY ts1
"
db2 "
WITH temp1 (ts1) AS
(VALUES ('1999-12-31 23:59:59') , ('2002-10-30 11:22:33')
)
SELECT ts1 ,to_date(ts1,'YYYY-MM-DD HH24:MI:SS') AS ts2
FROM temp1
ORDER BY ts1
"
--VARCHAR_FORMAT to_char
db2 "
WITH temp1 (ts1) AS
(VALUES (TIMESTAMP('1999-12-31-23.59.59')) , (TIMESTAMP('2002-10-30-11.22.33'))
)
SELECT ts1 ,char( to_char(ts1,'YYYY-MM-DD HH24:MI:SS'), 30 ) AS ts2
FROM temp1
ORDER BY ts1
"
db2 "
WITH temp1 (ts1) AS
(VALUES (TIMESTAMP('1999-12-31-23.59.59')) , (TIMESTAMP('2002-10-30-11.22.33'))
)
SELECT ts1 ,char( to_char(ts1,'YYYY-MM-DD HH24:MI:SS'), 30 ) AS ts2
FROM temp1
ORDER BY ts1
"
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22661144/viewspace-1477102/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
DB2导出模式 MBS 下的所有表
下一篇：
删除脚本-保留目录下最新的几个文件或目录
请登录后发表评论
登录
全部评论
