select to_char(a-1,'yyyy-mm-dd hh24:mi:ss'),to_char(a,'yyyy-mm-dd hh24:mi:ss'铅段) from (select trunc(to_date('友激腊2013-10-27 14:56:56'好滑,'yyyy-mm-dd hh24:mi:ss')) a from dual);
