SQL> desc timestamptest;
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
TP TIMESTAMP(6) Y sysdate
ID NUMBER Y SQL> select * from timestamptest;TP ID
-------------------------------------------------------------------------------- ----------
18-7月 -05 09.44.54.000000 上午 11
18-7月 -05 09.44.54.000000 上午 11
23-1月 -03 12.00.00.000000 上午 11SQL> SELECT to_char(tp,'dd-mm-yyyy hh24:mi:ss.ff') FROM TIMESTAMPTEST;TO_CHAR(TP,'DD-MM-YYYYHH24:MI:
------------------------------
18-07-2005 09:44:54.000000
18-07-2005 09:44:54.000000
23-01-2003 00:00:00.000000SQL>
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
TP TIMESTAMP(6) Y sysdate
ID NUMBER Y SQL> select * from timestamptest;TP ID
-------------------------------------------------------------------------------- ----------
18-7月 -05 09.44.54.000000 上午 11
18-7月 -05 09.44.54.000000 上午 11
23-1月 -03 12.00.00.000000 上午 11SQL> SELECT to_char(tp,'dd-mm-yyyy hh24:mi:ss.ff') FROM TIMESTAMPTEST;TO_CHAR(TP,'DD-MM-YYYYHH24:MI:
------------------------------
18-07-2005 09:44:54.000000
18-07-2005 09:44:54.000000
23-01-2003 00:00:00.000000SQL>
如:SELECT to_char(tp||'0','dd-mm-yyyy hh24:mi:ss.ff') FROM TIMESTAMPTEST