[DB2] timestamp_format

SELECT TIMESTAMP_FORMAT('2023-06-10.09.02.35.052000','YYYY/MM/DD HH24:MI:SS.NNNNNN') FROM SYSIBM.SYSDUMMY1;

 

참고 : https://www.ibm.com/docs/ko/db2/11.1?topic=functions-timestamp-format