mark_1994的博客

select t.insert_time,((t.clear_time-t.insert_time)::interval second(9) to second ::char(20) ::integer),extend(t.clear_time, year to second) from tab1 t 获得的第二个值是字段clear_time，insert_time相差的秒数，秒数差太大可...