Question

db2数据库to_char函数如何把时间格式化为yyyymmdd hh24,时间格式怎么写？

Answer 1

SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDD HH24') FROM SYSIBM.SYSDUMMY1;

Answer 2

Select to_char(sysdate,'YYYY/MM/DD HH24') FROM dual