日期格式化:
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
?
日期:2014-05-16 浏览次数:20319 次
日期格式化:
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
?