SQL> select systimestamp from dual;SYSTIMESTAMP
-----------------------------------------------------------------------
23-3月 -10 11.19.15.000001 上午 +08:00
如何格式化成‘yyyy-mm-dd'形式的?????
-----------------------------------------------------------------------
23-3月 -10 11.19.15.000001 上午 +08:00
如何格式化成‘yyyy-mm-dd'形式的?????
SQL> select systimestamp from dual;SYSTIMESTAMP
---------------------------------------------------------------------------
23-3月 -10 11.36.41.046000 上午 +08:00SQL> SELECT TO_CHAR(SYSTIMESTAMP,'yyyy-mm-dd') FROM DUAL;TO_CHAR(SY
----------
2010-03-23SQL>
systimestamp可取得毫秒,如:
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff3') from dual;