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 <bbev...@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*)