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 8f71dfc edit
8f71dfc is described below
commit 8f71dfc3e1e8aeaf24b3b3f12bd4aced4923b626
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Jan 10 16:50:42 2019 -0800
edit
---
_docs/sql-reference/sql-functions/010-math-and-trig.md | 7 ++++---
1 file changed, 4 insertions(+), 3 deletions(-)
diff --git a/_docs/sql-reference/sql-functions/010-math-and-trig.md
b/_docs/sql-reference/sql-functions/010-math-and-trig.md
index d7222a8..82827405 100644
--- a/_docs/sql-reference/sql-functions/010-math-and-trig.md
+++ b/_docs/sql-reference/sql-functions/010-math-and-trig.md
@@ -1,6 +1,6 @@
---
title: "Math and Trig"
-date: 2018-06-27 20:53:00 UTC
+date: 2019-01-11
parent: "SQL Functions"
---
Drill supports the math functions shown in the following table of math
functions plus trig functions listed at the end of this section. Most math
functions and all trig functions take these input types:
@@ -44,8 +44,9 @@ Exceptions are the LSHIFT and RSHIFT functions, which take
all types except FLOA
| RSHIFT(x, y) | Same as input | Shifts the binary x by y times to the right.
|
| SIGN(x) | INT | Returns the sign of x.
|
| SQRT(x) | Same as input | Returns the square root of x.
|
-| TRUNC(x, y) | Same as input | Truncates x to y decimal places. Specifying y
is optional. Default is 1. |
-| TRUNC(x, y) | DECIMAL | Truncates x to y decimal places.
|
+| TRUNC(x, y) | DOUBLE | Truncates x to y decimal places. Specifying y
is optional. Default is 0. |
+
+
## Math Function Examples
