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