日期:2014-05-16 浏览次数:20697 次
1.RR日期格式: 日期中RR与YY的区别,RR格式对日期作类似于舍入的操作,YY格式对日期作类似于截取的操作 RR YY 1995 27-oct-95 1995 1995 1995 27-oct-17 2017 1917 2001 27-oct-17 2017 2017 2001 27-oct-95 1995 2095 用法:select to_char(sysdate, 'YY') from dual; select to_char(to_date('95-11-27', 'RR-MM-DD'), 'YYYY-MM-DD') from dual; select to_char(to_date('95-11-27', 'YY-MM-DD'), 'YYYY-MM-DD') from dual;
?
?
http://wpc.29c4.edgecastcdn.net/8029C4/downloads/software/jira/downloads/atlassian-jira-5.0-x32.exe