This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new f5c6dd2 edit
f5c6dd2 is described below
commit f5c6dd2a337662102fc021370e96f37f6b09121f
Author: Bridget Bevens <[email protected]>
AuthorDate: Sat Dec 29 16:00:23 2018 -0800
edit
---
docs/date-time-functions-and-arithmetic/index.html | 14 +++++++-------
feed.xml | 4 ++--
2 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/docs/date-time-functions-and-arithmetic/index.html
b/docs/date-time-functions-and-arithmetic/index.html
index 3891524..568958c 100644
--- a/docs/date-time-functions-and-arithmetic/index.html
+++ b/docs/date-time-functions-and-arithmetic/index.html
@@ -1965,18 +1965,18 @@ SELECT UNIX_TIMESTAMP('2015-05-29 08:18:53.0',
'yyyy-MM-dd HH:mm:ss.
<li>You can include two date expressions, or one date expression with one
datetime expression. </li>
<li>Drill uses the <em>time_unit</em> to infer the return type.</li>
<li><p>You can include the <code>SQL_TSI_</code> prefix with the any of the
supported time units, as shown: </p>
-<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT TIMESTAMPADD(SQL_TSI_MINUTE,5,TIME '05:05:05');
-+-----------+
-| EXPR$0 |
-+-----------+
-| 05:10:05 |
-+-----------+
+<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT TIMESTAMPDIFF(SQL_TSI_MONTH, DATE '1982-05-06',
DATE '2018-12-26');
++---------+
+| EXPR$0 |
++---------+
+| 439 |
++---------+
</code></pre></div></li>
</ul>
<h3 id="timestampdiff-examples">TIMESTAMPDIFF Examples</h3>
-<p>Subtracts date literal 1982-05-06 from date literal 2018-12-26 and returns
the difference in months: </p>
+<p>Subtracts the date literal '1982-05-06' from the date literal
'2018-12-26' and returns the difference in months: </p>
<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT TIMESTAMPDIFF(MONTH, DATE'1982-05-06', DATE
'2018-12-26');
+---------+
| EXPR$0 |
diff --git a/feed.xml b/feed.xml
index 4276fb2..8e4249d 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Sat, 29 Dec 2018 15:47:43 -0800</pubDate>
- <lastBuildDate>Sat, 29 Dec 2018 15:47:43 -0800</lastBuildDate>
+ <pubDate>Sat, 29 Dec 2018 15:57:58 -0800</pubDate>
+ <lastBuildDate>Sat, 29 Dec 2018 15:57:58 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>