12小时制的nls_date_format hh:mi:ss默认是12小时制
SQL> alter session set nls_date_format='yyyy-mm-dd hh12:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2007-01-09 01:56:10
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2007-01-09 01:56:24
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2007-01-09 13:56:38
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss';
Session altered.
SQL> select sysdate from dual;
SYSDATE
-------------------
2007-01-09 01:56:48
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss pm';
Session altered.
SQL> select sysdate from dual;
SYSDATE
----------------------
2007-01-09 01:56:58 pm
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss am';
Session altered.
SQL> select sysdate from dual;
SYSDATE
----------------------
2007-01-09 01:57:10 pm
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9599/viewspace-472935/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9599/viewspace-472935/