select cast(to_date('2012-11-2 13:29:19','yyyy-mm-dd hh24:mi:ss') as timestamp) - cast(to_date('2012-11-2 13:27:14','yyyy-mm-dd hh24:mi:ss')as timestamp) from al
to_char(日期, 'yyyy-mm-dd')