Repository: trafodion-site
Updated Branches:
  refs/heads/asf-site 5ba321c26 -> 1a9c04b7b


http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/dependencies.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/dependencies.html 
b/docs/sql_reference/dependencies.html
index 270ca69..cf068b3 100644
--- a/docs/sql_reference/dependencies.html
+++ b/docs/sql_reference/dependencies.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/index.html b/docs/sql_reference/index.html
index f4c3ad0..709cb2c 100644
--- a/docs/sql_reference/index.html
+++ b/docs/sql_reference/index.html
@@ -1927,8 +1927,9 @@ table.CodeRay td.code>pre{padding:0}
 </li>
 <li><a href="#to_char_function">7.132. TO_CHAR Function</a>
 <ul class="sectlevel3">
-<li><a href="#considerations_for_to_char">7.132.1. Considerations for 
TO_CHAR</a></li>
-<li><a href="#examples_of_to_char">7.132.2. Examples of TO_CHAR</a></li>
+<li><a href="#to_char_syntax">7.132.1. Syntax Description of TO_CHAR</a></li>
+<li><a href="#considerations_for_to_char">7.132.2. Considerations for 
TO_CHAR</a></li>
+<li><a href="#examples_of_to_char">7.132.3. Examples of TO_CHAR</a></li>
 </ul>
 </li>
 <li><a href="#to_date_function">7.133. TO_DATE Function</a>
@@ -41090,7 +41091,7 @@ GROUP BY ROLLUP (delivery_year, region, 
product);</code></pre>
 <div class="ulist">
 <ul>
 <li>
-<p>First-level: the rows marked in <strong>blue</strong> are the total revenue 
for each year (<em>2016</em> and <em>2017</em>), each region (<em>A</em> and 
<em>B</em>) and each product (<em>Dress</em> and <em>Pullover</em>), they are 
caculated by GROUP BY instead of ROLLUP.</p>
+<p>First-level: the rows marked in <strong>blue</strong> are the total revenue 
for each year (<em>2016</em> and <em>2017</em>), each region (<em>A</em> and 
<em>B</em>) and each product (<em>Dress</em> and <em>Pullover</em>), they are 
calculated by GROUP BY instead of ROLLUP.</p>
 </li>
 <li>
 <p>Second-level: the rows marked in <strong>red</strong> provide the total 
revenue for the given <em>delivery_year</em> and <em>region</em> by 
<em>product</em>.</p>
@@ -43736,6 +43737,8 @@ second argument describes the format of the character 
value.</p>
 <pre class="CodeRay highlight"><code 
data-lang="text">TO_CHAR(character-expression [,format-string])</code></pre>
 </div>
 </div>
+<div class="sect3">
+<h4 id="to_char_syntax">7.132.1. Syntax Description of TO_CHAR</h4>
 <div class="ulist">
 <ul>
 <li>
@@ -43746,8 +43749,588 @@ second argument describes the format of the character 
value.</p>
 </li>
 <li>
 <p><code><em>format-string</em></code></p>
+<table class="tableblock frame-all grid-all spread">
+<caption class="title">Table 7. Details of 
<code><em>format-string</em></code></caption>
+<colgroup>
+<col style="width: 33.3333%;">
+<col style="width: 33.3333%;">
+<col style="width: 33.3334%;">
+</colgroup>
+<tbody>
+<tr>
+<td class="tableblock halign-center valign-middle"><p 
class="tableblock"><strong>Supported</strong> 
<code><em>character-expression</em></code></p></td>
+<td class="tableblock halign-center valign-middle"><p 
class="tableblock"><strong><code><em>format-string</em></code></strong></p></td>
+<td class="tableblock halign-center valign-middle"><p 
class="tableblock"><strong>Description</strong></p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'CC'</p></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">Two-digit century.</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'D'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Day of 
week (1-7), where 1 is Sunday, 6 is Saturday.<br>
+This is not configurable.</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'DD'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Day of 
month (01-31).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'DDD'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Day of 
year (001-366).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'DY'</p></td>
+<td class="tableblock halign-left valign-middle"><div><div class="paragraph">
+<p>Name of day, which is a three-letter abbreviation for the day in 
uppercase.<br></p>
+</div>
 <div class="paragraph">
-<p>is one of the following character string literals:</p>
+<p>The following values are returned:<br></p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>MON<br></p>
+</li>
+<li>
+<p>TUE<br></p>
+</li>
+<li>
+<p>WED<br></p>
+</li>
+<li>
+<p>THU<br></p>
+</li>
+<li>
+<p>FRI<br></p>
+</li>
+<li>
+<p>SAT<br></p>
+</li>
+<li>
+<p>SUN</p>
+</li>
+</ul>
+</div></div></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'DAY'</p></td>
+<td class="tableblock halign-left valign-middle"><div><div class="paragraph">
+<p>Name of day, which is full uppercase day name padded with blanks to the 
length of 9 characters.<br></p>
+</div>
+<div class="paragraph">
+<p>The following values are returned:<br></p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>MONDAY<br></p>
+</li>
+<li>
+<p>TUESDAY<br></p>
+</li>
+<li>
+<p>WEDSDAY<br></p>
+</li>
+<li>
+<p>THURSDAY<br></p>
+</li>
+<li>
+<p>FRIDAY<br></p>
+</li>
+<li>
+<p>SATURDAY<br></p>
+</li>
+<li>
+<p>SUNDAY</p>
+</li>
+</ul>
+</div></div></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>TIME</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'HH'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Hour of 
day in 24-hour format (00-23).<br>
+'HH' behaves the same as 'HH24'.</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>TIME</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'HH12'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Hour of 
day in 12-hour format (01-12).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>TIME</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'HH24'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Hour of 
day in 24-hour format (00-23).<br>
+'HH24' behaves the same as 'HH'.</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'J'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Julian 
date (that is, number of days since January 1, 4713 BC).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>TIME</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'MI'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Minute 
(00-59).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'MM'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Month 
(01-12).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'MON'</p></td>
+<td class="tableblock halign-left valign-middle"><div><div class="paragraph">
+<p>Month, which is a three-letter abbreviation for the month in 
uppercase.<br></p>
+</div>
+<div class="paragraph">
+<p>The following values are returned:<br></p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>JAN<br></p>
+</li>
+<li>
+<p>FEB<br></p>
+</li>
+<li>
+<p>MAR<br></p>
+</li>
+<li>
+<p>APR<br></p>
+</li>
+<li>
+<p>MAY<br></p>
+</li>
+<li>
+<p>JUN<br></p>
+</li>
+<li>
+<p>JUL<br></p>
+</li>
+<li>
+<p>AUG<br></p>
+</li>
+<li>
+<p>SEP<br></p>
+</li>
+<li>
+<p>OCT<br></p>
+</li>
+<li>
+<p>NOV<br></p>
+</li>
+<li>
+<p>DEC</p>
+</li>
+</ul>
+</div></div></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'Q'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Quarter 
(1-4).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>TIME</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'SS'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Second 
(00-59).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'W'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Week of 
month.</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'WW'</p></td>
+<td class="tableblock halign-left valign-middle"><div><div class="paragraph">
+<p>Week of year.<br></p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>The value 1 is returned for a datetime that occurs in the first 7 days of 
the year if the year begins on Sunday.<br>
+Otherwise, the value 1 is returned for a datetime that occurs in the partial 
week before the start of the first Sunday.</p>
+</li>
+<li>
+<p>The value <strong>53</strong> is returned for a datetime that occurs in the 
last full or partial week of the year.</p>
+</li>
+<li>
+<p>The value <strong>54</strong> is returned for a datetime that occurs in the 
last full or partial week of the leap year where begins on Saturday.</p>
+</li>
+</ul>
+</div></div></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'Y'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Last 
digit of year (0-9).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'YY'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Last 
two digits of year (00-99).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'YYY'</p></td>
+<td class="tableblock halign-left valign-middle"><p class="tableblock">Last 
three digits of year (000-999).</p></td>
+</tr>
+<tr>
+<td class="tableblock halign-left valign-middle"><div><div class="ulist">
+<ul>
+<li>
+<p><code><em>datetime-expression</em></code></p>
+<div class="ulist">
+<ul>
+<li>
+<p>DATE</p>
+</li>
+<li>
+<p>TIMESTAMP</p>
+</li>
+</ul>
+</div>
+</li>
+</ul>
+</div></div></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">'YYYY'</p></td>
+<td class="tableblock halign-left valign-middle"><p 
class="tableblock">Four-digit year (0001-9999).</p></td>
+</tr>
+</tbody>
+</table>
+<div class="paragraph">
+<p>Besides the <code><em>format-string</em></code> listed above, the following 
character string literals are also valid:</p>
 </div>
 <div class="ulist">
 <ul>
@@ -43828,73 +44411,836 @@ second argument describes the format of the 
character value.</p>
 </li>
 </ul>
 </div>
-</li>
-</ul>
-</div>
 <div class="paragraph">
-<p>Here, YYYY refers to a 4-digit year. YY refers to a two-digit year. MM 
refers to a two-digit month. MON refers to
-a three-letter abbreviation for month ('JAN', 'FEB', 'MAR', 'APR', 'MAY', 
'JUN', 'JUL', 'AUG', 'SEP',
-'OCT', 'NOV' or 'DEC'). MONTH refers to the month spelled out. In the output 
value, the month abbreviation or month
+<p>Here:</p>
+</div>
+<div class="ulist">
+<ul>
+<li>
+<p>YYYY refers to a four-digit year.</p>
+</li>
+<li>
+<p>YY refers to a two-digit year.</p>
+</li>
+<li>
+<p>MM refers to a two-digit month.</p>
+</li>
+<li>
+<p>MON refers to a three-letter abbreviation for month ('JAN', 'FEB', 'MAR', 
'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP',
+'OCT', 'NOV' or 'DEC').</p>
+</li>
+<li>
+<p>MONTH refers to the month spelled out. In the output value, the month 
abbreviation or month
 will appear in upper case.</p>
+</li>
+<li>
+<p>HH and HH24 refer to a two-digit hour field.</p>
+</li>
+<li>
+<p>MI refers to a two-digit minutes field.</p>
+</li>
+<li>
+<p>SS refers to a two-digit seconds field.</p>
+</li>
+<li>
+<p>If the <code><em>format-string</em></code> argument is omitted, 
'YYYY-MM-DD' is used as the
+default for date and timestamp values, and 'HH:MI:SS' is used for time 
values.</p>
+</li>
+</ul>
 </div>
-<div class="paragraph">
-<p>HH and HH24 refer to a 2-digit hour field. MI refers to a two-digit minutes 
field. SS refers to a 2-digit seconds field.</p>
+</li>
+</ul>
 </div>
-<div class="paragraph">
-<p>If the <em>format-string</em> argument is omitted, 'YYYY-MM-DD' is used as 
the
-default for date and timestamp values, and 'HH:MI:SS' is used for time 
values.</p>
 </div>
 <div class="sect3">
-<h4 id="considerations_for_to_char">7.132.1. Considerations for TO_CHAR</h4>
+<h4 id="considerations_for_to_char">7.132.2. Considerations for TO_CHAR</h4>
 <div class="paragraph">
-<p>If the <em>format-string</em> contains only hour, minute or seconds fields, 
the input data type must be time or timestamp.</p>
+<p>If the <code><em>format-string</em></code> contains only hour, minute or 
seconds fields, the input data type must be time or timestamp.</p>
 </div>
 <div class="paragraph">
-<p>If the <em>format-string</em> contains only year, month or day fields, the 
input data type must be date or timestamp.</p>
+<p>If the <code><em>format-string</em></code> contains only year, month or day 
fields, the input data type must be date or timestamp.</p>
 </div>
 <div class="paragraph">
-<p>If the <em>format-string</em> contains all fields, and the input data type 
is date, the hour, minute and second fields in the result will be filled with 
zeroes.</p>
+<p>If the <code><em>format-string</em></code> contains all fields, and the 
input data type is date, the hour, minute and second fields in the result will 
be filled with zeroes.</p>
 </div>
 </div>
 <div class="sect3">
-<h4 id="examples_of_to_char">7.132.2. Examples of TO_CHAR</h4>
+<h4 id="examples_of_to_char">7.132.3. Examples of TO_CHAR</h4>
+<div class="sect4">
+<h5 id="examples_of_to_char_cc">Examples of TO_CHAR (CC)</h5>
 <div class="ulist">
 <ul>
 <li>
-<p>This function returns the character value '01MAR2016':</p>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of century.</p>
 <div class="listingblock">
 <div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (DATE 
'2016-03-01', 'DDMONYYYY')</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-11-02','CC') FROM DUAL;
+
+(EXPR)
+------
+01
+
+--- 1 row(s) selected.</code></pre>
 </div>
 </div>
 </li>
 <li>
-<p>This function returns the character value '01.03.2016 00:00:00':</p>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of century.</p>
 <div class="listingblock">
 <div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (DATE 
'2016-03-01', 'DD.MM.YYYY HH24.MI.SS')</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '9899-12-31 23:59:59','CC') FROM DUAL;
+
+(EXPR)
+------
+99
+
+--- 1 row(s) selected.</code></pre>
 </div>
 </div>
 </li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_d">Examples of TO_CHAR (D)</h5>
+<div class="ulist">
+<ul>
 <li>
-<p>This function returns the character value '12:05:10':</p>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of day of week.</p>
 <div class="listingblock">
 <div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (TIME 
'12:05:10')</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2018-01-01','D') FROM DUAL;
+
+(EXPR)
+------
+2
+
+--- 1 row(s) selected.</code></pre>
 </div>
 </div>
 </li>
 <li>
-<p>This function returns the character value '20160301120510':</p>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of day of week.</p>
 <div class="listingblock">
 <div class="content">
-<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (TIMESTAMP 
'2016-03-01 12:05:10','YYYYMMDDHH24MISS')</code></pre>
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-04-01 23:59:59','D') FROM DUAL;
+
+(EXPR)
+------
+1
+
+--- 1 row(s) selected.</code></pre>
 </div>
 </div>
 </li>
 </ul>
 </div>
-<div style="page-break-after: always;"></div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_dd">Examples of TO_CHAR (DD)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of day of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2018-01-01','DD') FROM DUAL;
+
+(EXPR)
+------
+01
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of day of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-12-31 23:59:59','DD') FROM DUAL;
+
+(EXPR)
+------
+31
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_ddd">Examples of TO_CHAR (DDD)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of day of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2018-01-01','DDD') FROM DUAL;
+
+(EXPR)
+------
+001
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of day of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2020-12-31 23:59:59','DDD') FROM DUAL;
+
+(EXPR)
+------
+366
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_dy">Examples of TO_CHAR (DY)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of name of day (abbreviation).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2018-12-31','DY') FROM DUAL;
+
+(EXPR)
+------
+MON
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of name of day (abbreviation).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-02-14 23:59:59','DY') FROM DUAL;
+
+(EXPR)
+------
+THU
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_day">Examples of TO_CHAR (DAY)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of name of day.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2019-05-12','DAY') FROM DUAL;
+
+(EXPR)
+---------
+SUNDAY
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of name of day.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-12-24 23:59:59','DAY') FROM DUAL;
+
+(EXPR)
+---------
+TUESDAY
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_hh">Examples of TO_CHAR (HH)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>TIME</em></code> value to the character 
value of hour (24-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIME '00:00:01','HH') FROM DUAL;
+
+(EXPR)
+------
+00
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of hour (24-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 23:59:59','HH') FROM DUAL;
+
+(EXPR)
+------
+23
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_hh12">Examples of TO_CHAR (HH12)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>TIME</em></code> value to the character 
value of hour (12-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIME '01:00:00','HH12') FROM DUAL;
+
+(EXPR)
+------
+01
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of hour (12-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 12:59:59','HH12') FROM DUAL;
+
+(EXPR)
+------
+12
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_hh24">Examples of TO_CHAR (HH24)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>TIME</em></code> value to the character 
value of hour (24-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIME '00:00:01','HH24') FROM DUAL;
+
+(EXPR)
+------
+00
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of hour (24-hour format).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 23:59:59','HH24') FROM DUAL;
+
+(EXPR)
+------
+23
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_j">Examples of TO_CHAR (J)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example calculates the number of days since the beginning of the 
Julian epoch and converts the <code><em>DATE</em></code> value to the character 
value.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-01-01','J') FROM DUAL;
+
+(EXPR)
+-------
+1721426
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example calculates the number of days since the beginning of the 
Julian epoch and converts the <code><em>TIMESTAMP</em></code> value to the 
character value.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-11-02 23:59:59','J') FROM DUAL;;
+
+(EXPR)
+-------
+2458425
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_mi">Examples of TO_CHAR (MI)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>TIME</em></code> value to the character 
value of minute.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIME '01:00:02','MI') FROM DUAL;
+
+(EXPR)
+------
+00
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of minute.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 23:59:01','MI') FROM DUAL;
+
+(EXPR)
+------
+59
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_mm">Examples of TO_CHAR (MM)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-01-01','MM') FROM DUAL;
+
+(EXPR)
+------
+01
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 23:59:59','MM') FROM DUAL;
+
+(EXPR)
+------
+12
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_mon">Examples of TO_CHAR (MON)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-01-01','MON') FROM DUAL;
+
+(EXPR)
+------
+JAN
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-11-02 23:59:59','MON') FROM DUAL;
+
+(EXPR)
+------
+NOV
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_quarter">Examples of TO_CHAR (QUARTER)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of quarter.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-01-01','Q') FROM DUAL;
+
+(EXPR)
+------
+1
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of quarter.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-11-02 23:59:59','Q') FROM DUAL;
+
+(EXPR)
+------
+4
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_ss">Examples of TO_CHAR (SS)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>TIME</em></code> value to the character 
value of second.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIME '01:02:00','SS') FROM DUAL;
+
+(EXPR)
+------
+00
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of second.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2019-01-01 23:01:59','SS') FROM DUAL;
+
+(EXPR)
+------
+59
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_w">Examples of TO_CHAR (W)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2019-01-01','W') FROM DUAL;
+
+(EXPR)
+------
+1
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of month.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2018-04-30 23:59:59','W') FROM DUAL;
+
+(EXPR)
+------
+5
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_ww">Examples of TO_CHAR (WW)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '2016-01-03','WW') FROM DUAL;
+
+(EXPR)
+------
+02
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '2000-12-31 23:59:59','WW') FROM DUAL;
+
+(EXPR)
+------
+54
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_y">Examples of TO_CHAR (Y)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of year (last digit).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '1000-01-01','Y') FROM DUAL;
+
+(EXPR)
+------
+0
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of year (last digit).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '9999-12-31 23:59:59','Y') FROM DUAL;
+
+(EXPR)
+------
+9
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_yy">Examples of TO_CHAR (YY)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of year (last two digits).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '1000-01-01','YY') FROM DUAL;
+
+(EXPR)
+------
+00
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of year (last two digits).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '9999-12-31 23:59:59','YY') FROM DUAL;
+
+(EXPR)
+------
+99
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_yyy">Examples of TO_CHAR (YYY)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of year (last three digits).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '1000-01-01','YYY') FROM DUAL;
+
+(EXPR)
+------
+000
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of year (last three digits).</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '9999-12-31 23:59:59','YYY') FROM DUAL;
+
+(EXPR)
+------
+999
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_yyyy">Examples of TO_CHAR (YYYY)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This example converts the <code><em>DATE</em></code> value to the character 
value of week of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(DATE '0001-01-01','YYYY') FROM DUAL;
+
+(EXPR)
+------
+0001
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This example converts the <code><em>TIMESTAMP</em></code> value to the 
character value of week of year.</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">SQL&gt;SELECT TO_CHAR 
(TIMESTAMP '9999-12-31 23:59:59','YYYY') FROM DUAL;
+
+(EXPR)
+------
+9999
+
+--- 1 row(s) selected.</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+</div>
+<div class="sect4">
+<h5 id="examples_of_to_char_other">Examples of TO_CHAR (Other)</h5>
+<div class="ulist">
+<ul>
+<li>
+<p>This function returns the character value '01MAR2016':</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (DATE 
'2016-03-01', 'DDMONYYYY')</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This function returns the character value '01.03.2016 00:00:00':</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (DATE 
'2016-03-01', 'DD.MM.YYYY HH24.MI.SS')</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This function returns the character value '12:05:10':</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (TIME 
'12:05:10')</code></pre>
+</div>
+</div>
+</li>
+<li>
+<p>This function returns the character value '20160301120510':</p>
+<div class="listingblock">
+<div class="content">
+<pre class="CodeRay highlight"><code data-lang="text">TO_CHAR (TIMESTAMP 
'2016-03-01 12:05:10','YYYYMMDDHH24MISS')</code></pre>
+</div>
+</div>
+</li>
+</ul>
+</div>
+<div style="page-break-after: always;"></div>
+</div>
 </div>
 </div>
 <div class="sect2">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/integration.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/integration.html 
b/docs/sql_reference/integration.html
index ce1911c..d2bf37d 100644
--- a/docs/sql_reference/integration.html
+++ b/docs/sql_reference/integration.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/issue-tracking.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/issue-tracking.html 
b/docs/sql_reference/issue-tracking.html
index fb5c4db..c06c36a 100644
--- a/docs/sql_reference/issue-tracking.html
+++ b/docs/sql_reference/issue-tracking.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/license.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/license.html b/docs/sql_reference/license.html
index 5abcd5e..3c42e68 100644
--- a/docs/sql_reference/license.html
+++ b/docs/sql_reference/license.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/mail-lists.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/mail-lists.html 
b/docs/sql_reference/mail-lists.html
index 625d320..44a691f 100644
--- a/docs/sql_reference/mail-lists.html
+++ b/docs/sql_reference/mail-lists.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/project-info.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/project-info.html 
b/docs/sql_reference/project-info.html
index f367632..24589fe 100644
--- a/docs/sql_reference/project-info.html
+++ b/docs/sql_reference/project-info.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/project-summary.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/project-summary.html 
b/docs/sql_reference/project-summary.html
index f20d5b6..5dee0b0 100644
--- a/docs/sql_reference/project-summary.html
+++ b/docs/sql_reference/project-summary.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/source-repository.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/source-repository.html 
b/docs/sql_reference/source-repository.html
index 133d4f2..05a1349 100644
--- a/docs/sql_reference/source-repository.html
+++ b/docs/sql_reference/source-repository.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/docs/sql_reference/team-list.html
----------------------------------------------------------------------
diff --git a/docs/sql_reference/team-list.html 
b/docs/sql_reference/team-list.html
index 6a0482f..38471d0 100644
--- a/docs/sql_reference/team-list.html
+++ b/docs/sql_reference/team-list.html
@@ -1,5 +1,5 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
-<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-20 -->
+<!-- Generated by Apache Maven Doxia Site Renderer 1.4 at 2018-07-28 -->
 <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
@@ -10,7 +10,7 @@
       @import url("./css/site.css");
     </style>
     <link rel="stylesheet" href="./css/print.css" type="text/css" 
media="print" />
-    <meta name="Date-Revision-yyyymmdd" content="20180720" />
+    <meta name="Date-Revision-yyyymmdd" content="20180728" />
     <meta http-equiv="Content-Language" content="en" />
         
         </head>
@@ -27,7 +27,7 @@
             
                     
                 <div class="xleft">
-        <span id="publishDate">Last Published: 2018-07-20</span>
+        <span id="publishDate">Last Published: 2018-07-28</span>
                   &nbsp;| <span id="projectVersion">Version: 2.3.0</span>
                       </div>
             <div class="xright">                    <a href="./" 
title="Trafodion SQL Reference Manual">Trafodion SQL Reference Manual</a>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/index.html
----------------------------------------------------------------------
diff --git a/index.html b/index.html
index b634e7c..914e54b 100644
--- a/index.html
+++ b/index.html
@@ -532,4 +532,3 @@ Are you using Trafodion? We need permission to add your 
company's logo here. -->
 
        </body>
 </html>
- 

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/integration.html
----------------------------------------------------------------------
diff --git a/integration.html b/integration.html
index 26ed409..8bc0ec4 100644
--- a/integration.html
+++ b/integration.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/issue-tracking.html
----------------------------------------------------------------------
diff --git a/issue-tracking.html b/issue-tracking.html
index 60bedce..72f6201 100644
--- a/issue-tracking.html
+++ b/issue-tracking.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/license.html
----------------------------------------------------------------------
diff --git a/license.html b/license.html
index 134f2e2..7ee318d 100644
--- a/license.html
+++ b/license.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">
@@ -170,211 +170,7 @@
   <h3 id="The_Apache_Software_License_Version_2.0">The Apache Software 
License, Version 2.0</h3>
   <a name="The_Apache_Software_License_Version_2.0"></a> 
   <p>A business-friendly OSS license</p> 
-  <div class="source"> 
-   <pre>
-                                 Apache License
-                           Version 2.0, January 2004
-                        http://www.apache.org/licenses/
-
-   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
-
-   1. Definitions.
-
-      &quot;License&quot; shall mean the terms and conditions for use, 
reproduction,
-      and distribution as defined by Sections 1 through 9 of this document.
-
-      &quot;Licensor&quot; shall mean the copyright owner or entity authorized 
by
-      the copyright owner that is granting the License.
-
-      &quot;Legal Entity&quot; shall mean the union of the acting entity and 
all
-      other entities that control, are controlled by, or are under common
-      control with that entity. For the purposes of this definition,
-      &quot;control&quot; means (i) the power, direct or indirect, to cause the
-      direction or management of such entity, whether by contract or
-      otherwise, or (ii) ownership of fifty percent (50%) or more of the
-      outstanding shares, or (iii) beneficial ownership of such entity.
-
-      &quot;You&quot; (or &quot;Your&quot;) shall mean an individual or Legal 
Entity
-      exercising permissions granted by this License.
-
-      &quot;Source&quot; form shall mean the preferred form for making 
modifications,
-      including but not limited to software source code, documentation
-      source, and configuration files.
-
-      &quot;Object&quot; form shall mean any form resulting from mechanical
-      transformation or translation of a Source form, including but
-      not limited to compiled object code, generated documentation,
-      and conversions to other media types.
-
-      &quot;Work&quot; shall mean the work of authorship, whether in Source or
-      Object form, made available under the License, as indicated by a
-      copyright notice that is included in or attached to the work
-      (an example is provided in the Appendix below).
-
-      &quot;Derivative Works&quot; shall mean any work, whether in Source or 
Object
-      form, that is based on (or derived from) the Work and for which the
-      editorial revisions, annotations, elaborations, or other modifications
-      represent, as a whole, an original work of authorship. For the purposes
-      of this License, Derivative Works shall not include works that remain
-      separable from, or merely link (or bind by name) to the interfaces of,
-      the Work and Derivative Works thereof.
-
-      &quot;Contribution&quot; shall mean any work of authorship, including
-      the original version of the Work and any modifications or additions
-      to that Work or Derivative Works thereof, that is intentionally
-      submitted to Licensor for inclusion in the Work by the copyright owner
-      or by an individual or Legal Entity authorized to submit on behalf of
-      the copyright owner. For the purposes of this definition, 
&quot;submitted&quot;
-      means any form of electronic, verbal, or written communication sent
-      to the Licensor or its representatives, including but not limited to
-      communication on electronic mailing lists, source code control systems,
-      and issue tracking systems that are managed by, or on behalf of, the
-      Licensor for the purpose of discussing and improving the Work, but
-      excluding communication that is conspicuously marked or otherwise
-      designated in writing by the copyright owner as &quot;Not a 
Contribution.&quot;
-
-      &quot;Contributor&quot; shall mean Licensor and any individual or Legal 
Entity
-      on behalf of whom a Contribution has been received by Licensor and
-      subsequently incorporated within the Work.
-
-   2. Grant of Copyright License. Subject to the terms and conditions of
-      this License, each Contributor hereby grants to You a perpetual,
-      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
-      copyright license to reproduce, prepare Derivative Works of,
-      publicly display, publicly perform, sublicense, and distribute the
-      Work and such Derivative Works in Source or Object form.
-
-   3. Grant of Patent License. Subject to the terms and conditions of
-      this License, each Contributor hereby grants to You a perpetual,
-      worldwide, non-exclusive, no-charge, royalty-free, irrevocable
-      (except as stated in this section) patent license to make, have made,
-      use, offer to sell, sell, import, and otherwise transfer the Work,
-      where such license applies only to those patent claims licensable
-      by such Contributor that are necessarily infringed by their
-      Contribution(s) alone or by combination of their Contribution(s)
-      with the Work to which such Contribution(s) was submitted. If You
-      institute patent litigation against any entity (including a
-      cross-claim or counterclaim in a lawsuit) alleging that the Work
-      or a Contribution incorporated within the Work constitutes direct
-      or contributory patent infringement, then any patent licenses
-      granted to You under this License for that Work shall terminate
-      as of the date such litigation is filed.
-
-   4. Redistribution. You may reproduce and distribute copies of the
-      Work or Derivative Works thereof in any medium, with or without
-      modifications, and in Source or Object form, provided that You
-      meet the following conditions:
-
-      (a) You must give any other recipients of the Work or
-          Derivative Works a copy of this License; and
-
-      (b) You must cause any modified files to carry prominent notices
-          stating that You changed the files; and
-
-      (c) You must retain, in the Source form of any Derivative Works
-          that You distribute, all copyright, patent, trademark, and
-          attribution notices from the Source form of the Work,
-          excluding those notices that do not pertain to any part of
-          the Derivative Works; and
-
-      (d) If the Work includes a &quot;NOTICE&quot; text file as part of its
-          distribution, then any Derivative Works that You distribute must
-          include a readable copy of the attribution notices contained
-          within such NOTICE file, excluding those notices that do not
-          pertain to any part of the Derivative Works, in at least one
-          of the following places: within a NOTICE text file distributed
-          as part of the Derivative Works; within the Source form or
-          documentation, if provided along with the Derivative Works; or,
-          within a display generated by the Derivative Works, if and
-          wherever such third-party notices normally appear. The contents
-          of the NOTICE file are for informational purposes only and
-          do not modify the License. You may add Your own attribution
-          notices within Derivative Works that You distribute, alongside
-          or as an addendum to the NOTICE text from the Work, provided
-          that such additional attribution notices cannot be construed
-          as modifying the License.
-
-      You may add Your own copyright statement to Your modifications and
-      may provide additional or different license terms and conditions
-      for use, reproduction, or distribution of Your modifications, or
-      for any such Derivative Works as a whole, provided Your use,
-      reproduction, and distribution of the Work otherwise complies with
-      the conditions stated in this License.
-
-   5. Submission of Contributions. Unless You explicitly state otherwise,
-      any Contribution intentionally submitted for inclusion in the Work
-      by You to the Licensor shall be under the terms and conditions of
-      this License, without any additional terms or conditions.
-      Notwithstanding the above, nothing herein shall supersede or modify
-      the terms of any separate license agreement you may have executed
-      with Licensor regarding such Contributions.
-
-   6. Trademarks. This License does not grant permission to use the trade
-      names, trademarks, service marks, or product names of the Licensor,
-      except as required for reasonable and customary use in describing the
-      origin of the Work and reproducing the content of the NOTICE file.
-
-   7. Disclaimer of Warranty. Unless required by applicable law or
-      agreed to in writing, Licensor provides the Work (and each
-      Contributor provides its Contributions) on an &quot;AS IS&quot; BASIS,
-      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
-      implied, including, without limitation, any warranties or conditions
-      of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
-      PARTICULAR PURPOSE. You are solely responsible for determining the
-      appropriateness of using or redistributing the Work and assume any
-      risks associated with Your exercise of permissions under this License.
-
-   8. Limitation of Liability. In no event and under no legal theory,
-      whether in tort (including negligence), contract, or otherwise,
-      unless required by applicable law (such as deliberate and grossly
-      negligent acts) or agreed to in writing, shall any Contributor be
-      liable to You for damages, including any direct, indirect, special,
-      incidental, or consequential damages of any character arising as a
-      result of this License or out of the use or inability to use the
-      Work (including but not limited to damages for loss of goodwill,
-      work stoppage, computer failure or malfunction, or any and all
-      other commercial damages or losses), even if such Contributor
-      has been advised of the possibility of such damages.
-
-   9. Accepting Warranty or Additional Liability. While redistributing
-      the Work or Derivative Works thereof, You may choose to offer,
-      and charge a fee for, acceptance of support, warranty, indemnity,
-      or other liability obligations and/or rights consistent with this
-      License. However, in accepting such obligations, You may act only
-      on Your own behalf and on Your sole responsibility, not on behalf
-      of any other Contributor, and only if You agree to indemnify,
-      defend, and hold each Contributor harmless for any liability
-      incurred by, or claims asserted against, such Contributor by reason
-      of your accepting any such warranty or additional liability.
-
-   END OF TERMS AND CONDITIONS
-
-   APPENDIX: How to apply the Apache License to your work.
-
-      To apply the Apache License to your work, attach the following
-      boilerplate notice, with the fields enclosed by brackets &quot;[]&quot;
-      replaced with your own identifying information. (Don't include
-      the brackets!)  The text should be enclosed in the appropriate
-      comment syntax for the file format. We also recommend that a
-      file or class name and description of purpose be included on the
-      same &quot;printed page&quot; as the copyright notice for easier
-      identification within third-party archives.
-
-   Copyright [yyyy] [name of copyright owner]
-
-   Licensed under the Apache License, Version 2.0 (the &quot;License&quot;);
-   you may not use this file except in compliance with the License.
-   You may obtain a copy of the License at
-
-       http://www.apache.org/licenses/LICENSE-2.0
-
-   Unless required by applicable law or agreed to in writing, software
-   distributed under the License is distributed on an &quot;AS IS&quot; BASIS,
-   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-   See the License for the specific language governing permissions and
-   limitations under the License.
-</pre>
-  </div>
+  <p>Can't read the url [http://www.apache.org/licenses/LICENSE-2.0.txt] : 
connect timed out</p>
  </div>
 </div>
                        </div>

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/mail-lists.html
----------------------------------------------------------------------
diff --git a/mail-lists.html b/mail-lists.html
index 24775f4..abce257 100644
--- a/mail-lists.html
+++ b/mail-lists.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/modules.html
----------------------------------------------------------------------
diff --git a/modules.html b/modules.html
index 676e935..3da2bbd 100644
--- a/modules.html
+++ b/modules.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/project-info.html
----------------------------------------------------------------------
diff --git a/project-info.html b/project-info.html
index a4078df..3523a4b 100644
--- a/project-info.html
+++ b/project-info.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/project-summary.html
----------------------------------------------------------------------
diff --git a/project-summary.html b/project-summary.html
index b75999d..6bbfc98 100644
--- a/project-summary.html
+++ b/project-summary.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/source-repository.html
----------------------------------------------------------------------
diff --git a/source-repository.html b/source-repository.html
index a6011b8..689d1c8 100644
--- a/source-repository.html
+++ b/source-repository.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

http://git-wip-us.apache.org/repos/asf/trafodion-site/blob/1a9c04b7/team-list.html
----------------------------------------------------------------------
diff --git a/team-list.html b/team-list.html
index 2b86e93..8d8af98 100644
--- a/team-list.html
+++ b/team-list.html
@@ -1,7 +1,7 @@
 
 <!DOCTYPE html>
 <!--
- Generated by Apache Maven Doxia at 2018-07-20
+ Generated by Apache Maven Doxia at 2018-07-28
  Rendered using Reflow Maven Skin 1.1.1 
(http://andriusvelykis.github.io/reflow-maven-skin)
 -->
 <html  xml:lang="en" lang="en">

Reply via email to