ORACLE——日期时间格式化参数详解 之一

2.2 AD/A.D. 公元标识

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">AD yyyy-mm-dd</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">ADYYYY-MM-DD</span><span style="color: #ff0000">‘</span>
<span style="color: #008080">--</span><span style="color: #008080">----------------------------</span>
公元 <span style="color: #800000; font-weight: bold">2015</span><span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">12</span><span style="color: #808080">-</span><span style="color: #800000; font-weight: bold">28</span><span style="color: #000000">
SQL</span><span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">A.D. yyyy-mm-dd</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">A.D.YYYY-MM-D
------------------------------
公元 2015-12-28</span>

2.3 BC/B.C. 公元标识

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">B.C. yyyy-mm-dd</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">B.C.YYYY-MM-D
------------------------------
公元 2015-12-28
SQL> select to_char(sysdate,</span><span style="color: #ff0000">‘</span>BC yyyy<span style="color: #808080">-</span>mm<span style="color: #808080">-</span>dd<span style="color: #ff0000">‘</span><span style="color: #ff0000">) from dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span>BCYYYY<span style="color: #808080">-</span>MM<span style="color: #808080">-</span>DD<span style="color: #ff0000">‘</span><span style="color: #ff0000">
------------------------------
**公元** 2015-12-28</span>

2.4 AM/A.M. 子午线标识

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">YYYY-MM-DD AM hh24:mi:ss</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">YYYY-MM-DDAMH
------------------------------
2015-12-27 **下午** 17:52:58</span>

2.5 PM/P.M. 子午线标识

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">YYYY-MM-DD PM hh24:mi:ss</span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">YYYY-MM-DDPMH
------------------------------
2015-12-27 **下午** 17:54:29</span>

2.6 CC/SCC 世纪标识，S前缀指定如遇公元前的显示，会在显示前加(-)

<code>提示：
如果年份中最后两位数字在01到99(含)之间，则返回值等于年份前两位+1
如果年份中最后两位数字是00，则返回值与年份前两位相同</code><br><br>

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">cc YYYY-MM-DD PM hh24:mi:ss </span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">CCYYYY-MM-DDP
------------------------------
**21** 2015-12-27 下午 17:57:10</span>

2.7 D 获取日期星期几(范围：1-7)

SQL<span style="color: #808080">></span> <span style="color: #0000ff">select</span> to_char(sysdate,<span style="color: #ff0000">‘</span><span style="color: #ff0000">D YYYY-MM-DD PM hh24:mi:ss </span><span style="color: #ff0000">‘</span>) <span style="color: #0000ff">from</span><span style="color: #000000"> dual;
TO_CHAR(SYSDATE,</span><span style="color: #ff0000">‘</span><span style="color: #ff0000">DYYYY-MM-DDPM
------------------------------
1 2015-12-27 下午 18:09:43</span>

<br><br><br>

ORACLE——日期时间格式化参数详解 之一

标签：logs   nbsp   ada   参数详解   .mm   char   sql   提示   星期几