DB2获取当前时间戳并转日期

SELECT CAST(CURRENT_TIMESTAMP AS DATE) AS 日期 FROM TABLE

DB2截取日期元素并拼接

SELECT EXTRACT(YEAR FROM CURRENT_TIMESTAMP) || '-' ||
SELECT EXTRACT(MONTH FROM CURRENT_TIMESTAMP) || '-' ||
SELECT EXTRACT(DAY FROM CURRENT_TIMESTAMP) || ' ' ||
SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP) || ':' ||
SELECT EXTRACT(MINUTE FROM CURRENT_TIMESTAMP) || ':' ||
SELECT EXTRACT(SECOND FROM CURRENT_TIMESTAMP) || AS 日期时间
FROM TABLE