17,140
社区成员




实不行,写函数转化好了!
[SYS@myoracle] SQL>select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
14-11月-11 02.54.45.006000 下午 +08:00
[SYS@myoracle] SQL>show parameter nls_t
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_time_format string
nls_time_tz_format string
nls_timestamp_format string
nls_timestamp_tz_format string
[SYS@myoracle] SQL>alter session set nls_timestamp_tz_format = 'yyyy-mm-dd';
会话已更改。
[SYS@myoracle] SQL>select current_timestamp from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
2011-11-14
[SYS@myoracle] SQL>