最简单的timestamp转date

废话不多说，直接看结果

SQL> select SYSTIMESTAMP FROM DUAL;

SYSTIMESTAMP
--------------------------------------------------------------------------------
03-2月 -10 02.27.52.376539 下午 +08:00

SQL> SELECT SYSTIMESTAMP FROM DUAL;

SYSTIMESTAMP
--------------------------------------------------------------------------------
30-7月 -14 02.28.06.425351 下午 +08:00

SQL> SELECT SYSTIMESTAMP+0 FROM DUAL;

SYSTIMESTAMP+0
--------------
2014-07-30 10:13

                                         简单么，简单你就点赞哦。

                                                                                          By：lsfhack@163.com QQ：858084865