oracle select second

2016-05-09

create_time second

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select create_time,company_id from chat_archive where status<>2 order by create_time;