日期处理完全版
TO_DATE格式
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98
yyyy four digits 1998
24小时格式下时间范围为: 0:00:00 - 23:59:59....
12小时格式下时间范围为: 1:00:00 - 12:59:59 ....
DD-MON-YYYY:05-JAN-2007或05-1月-2007
查询服务器端:select * from nls_database_parameter;select * from V$NLS_PARAMETERS;
查询客户端:select userenv('language') from dual;