VARCHAR_FORMAT
Converts a timestamp value into a string with the format: "YYYY-MM-DD HH:MM:SS".
The TIMESTAMP_FORMAT function does the inverse.
WITH temp1 (ts1) AS
(VALUES (TIMESTAMP('1999-12-31-23.59.59'))
,(TIMESTAMP('2002-10-30-11.22.33'))
)
SELECT ts1
,VARCHAR_FORMAT(ts1,'YYYY-MM-DD HH24:MI:SS') AS ts2
FROM temp1
ORDER BY ts1;
SELECT VARCHAR_FORMAT(CURRENT_DATE,'YYYY-MM-DD') FROM SYSIBM.SYSDUMMY1;
SELECT VARCHAR_FORMAT(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS') FROM SYSIBM.SYSDUMMY1


TIMESTAMP_FORMAT
Takes an input string with the format: "YYYY-MM-DD HH:MM:SS" and converts it into a
valid timestamp value. The VARCHAR_FORMAT function does the inverse.
WITH temp1 (ts1) AS
(VALUES ('1999-12-31 23:59:59')
,('2002-10-30 11:22:33')
)
SELECT ts1
,TIMESTAMP_FORMAT(ts1,'YYYY-MM-DD HH24:MI:SS') AS ts2
FROM temp1
ORDER BY ts1;