3,490
社区成员
发帖
与我相关
我的任务
分享
[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>
到服务器上执行一下!