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 0e32ed8 edit
0e32ed8 is described below
commit 0e32ed89a2349cf58b1fc376e45e48bd455d3947
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Dec 20 15:36:16 2018 -0800
edit
---
.../sql-functions/020-data-type-conversion.md | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index 7d68674..9ce1081 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -10,14 +10,14 @@ Drill supports the following functions for casting and
converting data types:
* [STRING_BINARY]({{ site.baseurl
}}/docs/data-type-conversion/#string_binary-function) and [BINARY_STRING]({{
site.baseurl }}/docs/data-type-conversion/#binary_string-function)
* [Other Data Type Conversions]({{ site.baseurl
}}/docs/data-type-conversion/#other-data-type-conversions)
-**Note:** Starting in Drill 1.15, all cast and data type conversion functions
return an empty string ('') as null when the
`drill.exec.functions.cast_empty_string_to_null` option is enabled, for
example:
-
- SELECT CAST('' AS DATE) FROM (VALUES(1));
- +---------+
- | EXPR$0 |
- +---------+
- | null |
- +---------+
+**Note:** Starting in Drill 1.15, all cast and data type conversion functions
return null for an empty string ('') when the
`drill.exec.functions.cast_empty_string_to_null` option is enabled, for
example:
+
+ SELECT CAST('' AS DATE), TO_TIMESTAMP('', 'yyyy-MM-dd HH:mm:ss') FROM
(VALUES(2));
+ +---------+---------+
+ | EXPR$0 | EXPR$1 |
+ +---------+---------+
+ | null | null |
+ +---------+---------+
Prior to 1.15, casting an empty string to null only worked for numeric types;
in Drill 1.15 and later casting an empty string to null also works for date and
time data types, including DATE, TIME, TIMESTAMP, INTERVAL YEAR, INTERVAL
MONTH, and INTERVAL DAY.
