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 3ab8aaa edit
3ab8aaa is described below
commit 3ab8aaa0ed9a2448660b1c6bdf50b904acc0cad1
Author: Bridget Bevens <[email protected]>
AuthorDate: Sat Dec 29 15:54:08 2018 -0800
edit
---
.../sql-functions/030-date-time-functions-and-arithmetic.md | 12 ++++++------
1 file changed, 6 insertions(+), 6 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 a3acbdd..9d0833e 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
@@ -635,12 +635,12 @@ TIMESTAMPDIFF(*time\_unit, datetime\_expression1,
datetime\_expression2*)
- Drill uses the *time\_unit* to infer the return type.
- You can include the `SQL_TSI_` prefix with the any of the supported time
units, as shown:
- SELECT TIMESTAMPADD(SQL_TSI_MINUTE,5,TIME '05:05:05');
- +-----------+
- | EXPR$0 |
- +-----------+
- | 05:10:05 |
- +-----------+
+ SELECT TIMESTAMPDIFF(SQL_TSI_MONTH, DATE '1982-05-06', DATE
'2018-12-26');
+ +---------+
+ | EXPR$0 |
+ +---------+
+ | 439 |
+ +---------+
###TIMESTAMPDIFF Examples
