一些常用是時間格式select TO_CHAR(SYSDATE,'HH24:MI:SS AM') from dual ---12:56:40 下午select TO_CHAR(TO_DATE('21-
select to_date('2005-12-25,13:25:59','yyyy-mm-dd,hh34:mi:ss') from dual
