日期轉換問題

Question

SQL> select to_char(to_timestamp('2005-12-29 16.44.41.447919','yyyy-mm-dd hh24.mi.ss.ff') + 60,'mm/dd/yyyy') from dual;TO_CHAR(TO_TIMESTAMP('2005-12-
------------------------------
02/27/2006

Answer 1

9i或更高版本。
select to_char(to_timestamp('2005-12-29 16.44.41.447919','yyyy-mm-dd hh24.mi.ss.ff6')+90,'MM/DD/YYYY') from dual;

Answer 2

如果只是日期的话，只要
SQL> select to_char(to_date(substr('2005-12-29 16.44.41.447919',0,10), 'yyyy-mm-
dd')+60, 'mm/dd/yyyy') from dual;TO_CHAR(TO
----------
02/27/2006