日期格式化:
select varchar_format(current timestamp,'yyyy-mm-dd hh24:mm:ss') from SYSIBM.DUAL
--除了 varchar_format,还可以用to_char
select TO_CHAR(current timestamp, 'yyyy-mm-dd hh24:mi:ss') from SYSIBM.DUAL
日期格式化:
select varchar_format(current timestamp,'yyyy-mm-dd hh24:mm:ss') from SYSIBM.DUAL
--除了 varchar_format,还可以用to_char
select TO_CHAR(current timestamp, 'yyyy-mm-dd hh24:mi:ss') from SYSIBM.DUAL