select to_char(字段名,'yyyy-mm-dd hh24:mi:ss') from 表名
select to_timestamp(date,'yyyy-mm-dd hh24:mi:ss') time_format from dual
