You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by tw...@apache.org on 2018/12/13 13:01:35 UTC

[flink] branch release-1.6 updated: [hotfix] [docs] Add notice about buggy DATE_FORMAT function

This is an automated email from the ASF dual-hosted git repository.

twalthr pushed a commit to branch release-1.6
in repository https://gitbox.apache.org/repos/asf/flink.git


The following commit(s) were added to refs/heads/release-1.6 by this push:
     new a3c86df  [hotfix] [docs] Add notice about buggy DATE_FORMAT function
a3c86df is described below

commit a3c86df9018d24895725adcf78924f05812225a1
Author: Timo Walther <tw...@apache.org>
AuthorDate: Thu Dec 13 14:00:48 2018 +0100

    [hotfix] [docs] Add notice about buggy DATE_FORMAT function
---
 docs/dev/table/sql.md      | 3 +--
 docs/dev/table/tableApi.md | 6 ++----
 2 files changed, 3 insertions(+), 6 deletions(-)

diff --git a/docs/dev/table/sql.md b/docs/dev/table/sql.md
index 33c9aed..2bc7549 100644
--- a/docs/dev/table/sql.md
+++ b/docs/dev/table/sql.md
@@ -2187,8 +2187,7 @@ DATE_FORMAT(timestamp, format)
 {% endhighlight %}
       </td>
       <td>
-        <p>Formats <code>timestamp</code> as a string using a specified <code>format</code> string. The format must be compatible with MySQL's date formatting syntax as used by the <code>date_parse</code> function. The format specification is given in the <a href="#date-format-specifier">Date Format Specifier table</a> below.</p>
-        <p>For example <code>DATE_FORMAT(ts, '%Y, %d %M')</code> results in strings formatted as <code>"2017, 05 May"</code>.</p>
+        <p><span class="label label-danger">Attention</span> This function has serious bugs and should not be used for now. Please implement a custom UDF instead or use EXTRACT as a workaround.</p>
       </td>
     </tr>
 
diff --git a/docs/dev/table/tableApi.md b/docs/dev/table/tableApi.md
index 2aa3063..4b14ee4 100644
--- a/docs/dev/table/tableApi.md
+++ b/docs/dev/table/tableApi.md
@@ -2809,8 +2809,7 @@ dateFormat(TIMESTAMP, STRING)
 {% endhighlight %}
       </td>
       <td>
-        <p>Formats <code>timestamp</code> as a string using a specified <code>format</code>. The format must be compatible with MySQL's date formatting syntax as used by the <code>date_parse</code> function. The format specification is given in the <a href="sql.html#date-format-specifier">Date Format Specifier table</a> below.</p>
-        <p>For example <code>dateFormat(ts, '%Y, %d %M')</code> results in strings formatted as <code>"2017, 05 May"</code>.</p>
+        <p><span class="label label-danger">Attention</span> This function has serious bugs and should not be used for now. Please implement a custom UDF instead or use extract() as a workaround.</p>
       </td>
     </tr>
 
@@ -4484,8 +4483,7 @@ dateFormat(TIMESTAMP, STRING)
 {% endhighlight %}
       </td>
       <td>
-        <p>Formats <code>timestamp</code> as a string using a specified <code>format</code>. The format must be compatible with MySQL's date formatting syntax as used by the <code>date_parse</code> function. The format specification is given in the <a href="sql.html#date-format-specifier">Date Format Specifier table</a> below.</p>
-        <p>For example <code>dateFormat('ts, "%Y, %d %M")</code> results in strings formatted as <code>"2017, 05 May"</code>.</p>
+        <p><span class="label label-danger">Attention</span> This function has serious bugs and should not be used for now. Please implement a custom UDF instead or use extract() as a workaround.</p>
       </td>
     </tr>