You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2018/12/27 03:29:04 UTC
[drill] branch gh-pages updated: Doc edits
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 8ba3342 Doc edits
8ba3342 is described below
commit 8ba33424354a2b48f92eba515302ef7d21e4cb45
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Wed Dec 26 19:28:14 2018 -0800
Doc edits
---
.../sql-functions/030-date-time-functions-and-arithmetic.md | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md b/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
index 1179d26..177b493 100644
--- a/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
+++ b/_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md
@@ -23,8 +23,8 @@ This section covers the Drill [time zone limitation]({{site.baseurl}}/docs/data-
[NOW]({{ site.baseurl }}/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions) | TIMESTAMP
[TIMEOFDAY]({{ site.baseurl }}/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions) | VARCHAR
[UNIX_TIMESTAMP]({{ site.baseurl }}/docs/date-time-functions-and-arithmetic/#unix_timestamp) | BIGINT
-[TIMESTAMPADD]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#TIMESTAMPADD) | Inferred based on unit of time
-[TIMESTAMPDIFF]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#TIMESTAMPDIFF) | Inferred based on unit of time |
+[TIMESTAMPADD]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#timestampadd) | Inferred based on unit of time
+[TIMESTAMPDIFF]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#timestampdiff) | Inferred based on unit of time |
|
## AGE
@@ -629,7 +629,7 @@ Add three days to the given date:
+------------------------+
##TIMESTAMPDIFF
-Calculates an interval of time, in the given time units, by subtracting *datetime\_expression2* from *datetime\_expression1*.
+Calculates an interval of time, in the given time units, by subtracting *datetime\_expression1* from *datetime\_expression2* (*datetime\_expression2* − *datetime\_expression1*).
###TIMESTAMPDIFF Syntax
TIMESTAMPDIFF(*time\_unit,datetime\_expression1,datetime\_expression2*)