Author: rajeshbabu Date: Fri May 22 01:33:41 2015 New Revision: 1680974 URL: http://svn.apache.org/r1680974 Log: PHOENIX-1817 Document new date/time built-in functions in Functions reference guide(Alicia Ying Shu)
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv phoenix/site/publish/language/functions.html Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv URL: http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1680974&r1=1680973&r2=1680974&view=diff ============================================================================== --- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original) +++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Fri May 22 01:33:41 2015 @@ -1699,6 +1699,70 @@ Returns offset (shift in minutes) of a t TIMEZONE_OFFSET('Indian/Cocos', myDate) " +"Functions (Time and Date)","NOW"," +NOW() +"," +Returns the current date, bound at the start of the execution of a query based on the current time on the region server owning the metadata of the table being queried. +"," +NOW() +" + +"Functions (Time and Date)","YEAR"," +YEAR(dateTerm|timeTerm|timestampTerm) +"," +Returns the year of the specified date. +"," +YEAR(TO_DATE('2015-6-05')) +" + +"Functions (Time and Date)","MONTH"," +MONTH(dateTerm|timeTerm|timestampTerm) +"," +Returns the month of the specified date. +"," +MONTH(TO_TIMESTAMP('2015-6-05')) +" + +"Functions (Time and Date)","WEEK"," +WEEK(dateTerm|timeTerm|timestampTerm) +"," +Returns the week of the specified date. +"," +WEEK(TO_TIME('2010-6-15')) +" + +"Functions (Time and Date)","DAYOFMONTH"," +DAYOFMONTH(dateTerm|timeTerm|timestampTerm) +"," +Returns the day of the month of the specified date. +"," +DAYOFMONTH(TO_DATE('2004-01-18 10:00:10')) +" + +"Functions (Time and Date)","HOUR"," +HOUR(dateTerm|timeTerm|timestampTerm) +"," +Returns the hour of the specified date. +"," +HOUR(TO_TIMESTAMP('2015-6-05')) +" + +"Functions (Time and Date)","MINUTE"," +MINUTE(dateTerm|timeTerm|timestampTerm) +"," +Returns the minute of the specified date. +"," +MINUTE(TO_TIME('2015-6-05')) +" + +"Functions (Time and Date)","SECOND"," +SECOND(dateTerm|timeTerm|timestampTerm) +"," +Returns the second of the specified date. +"," +SECOND(TO_DATE('2015-6-05')) +" + "Functions (General)","COALESCE"," COALESCE( firstTerm, secondTerm ) "," Modified: phoenix/site/publish/language/functions.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1680974&r1=1680973&r2=1680974&view=diff ============================================================================== --- phoenix/site/publish/language/functions.html (original) +++ phoenix/site/publish/language/functions.html Fri May 22 01:33:41 2015 @@ -292,6 +292,22 @@ syntax-end --> <a href="#convert_tz" >CONVERT_TZ</a><br /> <a href="#timezone_offset" >TIMEZONE_OFFSET</a><br /> + + <a href="#now" >NOW</a><br /> + + <a href="#year" >YEAR</a><br /> + + <a href="#month" >MONTH</a><br /> + + <a href="#week" >WEEK</a><br /> + + <a href="#dayofmonth" >DAYOFMONTH</a><br /> + + <a href="#hour" >HOUR</a><br /> + + <a href="#minute" >MINUTE</a><br /> + + <a href="#second" >SECOND</a><br /> </p> syntax-end --> <!-- railroad-start --> @@ -302,14 +318,30 @@ syntax-end --> <a href="#to_date" >TO_DATE</a><br /> <a href="#current_date" >CURRENT_DATE</a><br /> - </td><td class="index"> <a href="#current_time" >CURRENT_TIME</a><br /> <a href="#convert_tz" >CONVERT_TZ</a><br /> - </td><td class="index"> <a href="#timezone_offset" >TIMEZONE_OFFSET</a><br /> + </td><td class="index"> + + <a href="#now" >NOW</a><br /> + + <a href="#year" >YEAR</a><br /> + + <a href="#month" >MONTH</a><br /> + + <a href="#week" >WEEK</a><br /> + + <a href="#dayofmonth" >DAYOFMONTH</a><br /> + </td><td class="index"> + + <a href="#hour" >HOUR</a><br /> + + <a href="#minute" >MINUTE</a><br /> + + <a href="#second" >SECOND</a><br /> </td> </tr> </table> @@ -1275,6 +1307,150 @@ syntax-end --> <p>Example:</p> <p class="notranslate">TIMEZONE_OFFSET('Indian/Cocos', myDate)</p> +<h3 id="now" class="notranslate">NOW</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +NOW() +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="d"><code class="c">NOW ( )</code></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +NOW() +</pre> +syntax-end --> +<p>Returns the current date, bound at the start of the execution of a query based on the current time on the region server owning the metadata of the table being queried.</p> +<p>Example:</p> +<p class="notranslate">NOW()</p> + +<h3 id="year" class="notranslate">YEAR</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +YEAR(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">YEAR ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +YEAR(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the year of the specified date.</p> +<p>Example:</p> +<p class="notranslate">YEAR(TO_DATE('2015-6-05'))</p> + +<h3 id="month" class="notranslate">MONTH</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +MONTH(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">MONTH ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +MONTH(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the month of the specified date.</p> +<p>Example:</p> +<p class="notranslate">MONTH(TO_TIMESTAMP('2015-6-05'))</p> + +<h3 id="week" class="notranslate">WEEK</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +WEEK(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">WEEK ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +WEEK(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the week of the specified date.</p> +<p>Example:</p> +<p class="notranslate">WEEK(TO_TIME('2010-6-15'))</p> + +<h3 id="dayofmonth" class="notranslate">DAYOFMONTH</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +DAYOFMONTH(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">DAYOFMONTH ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +DAYOFMONTH(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the day of the month of the specified date.</p> +<p>Example:</p> +<p class="notranslate">DAYOFMONTH(TO_DATE('2004-01-18 10:00:10'))</p> + +<h3 id="hour" class="notranslate">HOUR</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +HOUR(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">HOUR ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +HOUR(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the hour of the specified date.</p> +<p>Example:</p> +<p class="notranslate">HOUR(TO_TIMESTAMP('2015-6-05'))</p> + +<h3 id="minute" class="notranslate">MINUTE</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +MINUTE(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">MINUTE ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +MINUTE(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the minute of the specified date.</p> +<p>Example:</p> +<p class="notranslate">MINUTE(TO_TIME('2015-6-05'))</p> + +<h3 id="second" class="notranslate">SECOND</h3> +<!-- railroad-start --> +<pre name="bnf" style="display: none"> +SECOND(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +<div name="railroad"> +<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">SECOND ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></td><td class="ke"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table> +</div> +<!-- railroad-end --> +<!-- syntax-start +<pre> +SECOND(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>) +</pre> +syntax-end --> +<p>Returns the second of the specified date.</p> +<p>Example:</p> +<p class="notranslate">SECOND(TO_DATE('2015-6-05'))</p> + <!-- [close] { --> <!-- } -->