This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 5bf088d edit
5bf088d is described below
commit 5bf088d6a8b49ef895de6268ef8b80daaa34837b
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Dec 20 15:41:23 2018 -0800
edit
---
docs/data-type-conversion/index.html | 14 +++++++-------
feed.xml | 4 ++--
2 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/docs/data-type-conversion/index.html
b/docs/data-type-conversion/index.html
index bc9dbfd..2c7f087 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -1308,13 +1308,13 @@
<li><a href="/docs/data-type-conversion/#other-data-type-conversions">Other
Data Type Conversions</a><br></li>
</ul>
-<p><strong>Note:</strong> Starting in Drill 1.15, all cast and data type
conversion functions return an empty string ('') as null when the
<code>drill.exec.functions.cast_empty_string_to_null</code> option is enabled,
for example: </p>
-<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT CAST('' AS DATE) FROM (VALUES(1));
-+---------+
-| EXPR$0 |
-+---------+
-| null |
-+---------+
+<p><strong>Note:</strong> Starting in Drill 1.15, all cast and data type
conversion functions return null for an empty string ('') when the
<code>drill.exec.functions.cast_empty_string_to_null</code> option is enabled,
for example: </p>
+<div class="highlight"><pre><code class="language-text"
data-lang="text">SELECT CAST('' AS DATE), TO_TIMESTAMP('',
'yyyy-MM-dd HH:mm:ss') FROM (VALUES(2));
++---------+---------+
+| EXPR$0 | EXPR$1 |
++---------+---------+
+| null | null |
++---------+---------+
</code></pre></div>
<p>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.</p>
diff --git a/feed.xml b/feed.xml
index c14bc01..0d3ebf0 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 20 Dec 2018 11:50:53 -0800</pubDate>
- <lastBuildDate>Thu, 20 Dec 2018 11:50:53 -0800</lastBuildDate>
+ <pubDate>Thu, 20 Dec 2018 15:39:02 -0800</pubDate>
+ <lastBuildDate>Thu, 20 Dec 2018 15:39:02 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>