Delete Incorrect Examples
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/0a4141e4 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/0a4141e4 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/0a4141e4 Branch: refs/heads/master Commit: 0a4141e44060fdc002bfdaf4979242a11a62901c Parents: 6d634b5 Author: liu.yu <qwerty...@hotmail.com> Authored: Thu Aug 9 11:59:36 2018 +0800 Committer: liu.yu <qwerty...@hotmail.com> Committed: Thu Aug 9 11:59:36 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_clauses.adoc | 24 -------------------- 1 file changed, 24 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/0a4141e4/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc index 9c44673..fab123b 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_clauses.adoc @@ -267,12 +267,6 @@ clause must be a numeric value or a string value. SELECT 'abcde' (FORMAT 'XXX') FROM (VALUES(1)) t; ``` -* The format string 'YYYY-MM_DD' in this example will yield a sample result of 2008-07-17. -+ -``` -SELECT CAST('2008-07-17' AS DATE) (FORMAT 'YYYY-MM-DD') FROM (VALUES(1)) t; -``` - * The format string 'MM/DD/YYYY' in this example will yield a sample result of 07/17/2008. + ``` @@ -303,24 +297,6 @@ SELECT '2008-07-17' (DATE, FORMAT 'YYYYMMDD') FROM (VALUES(1)) t; SELECT '2008-07-17' (DATE, FORMAT 'DD.MM.YYYY') FROM (VALUES(1)) t; ``` -* The format string 'DD-MMM-YYYY' in this example will yield a sample result of 17âJUL-2008. -+ -``` -SELECT '2008-07-17' (DATE, FORMAT 'DD-MMM-YYYY') FROM (VALUES(1)) t; -``` - -* The format string '99:99:99:99' in this example will yield a sample result of 12:34:56:78. -+ -``` -SELECT 12345678 (FORMAT '99:99:99:99') FROM (VALUES(1)) t; -``` - -* The format string '-99:99:99:99' in this example will yield a sample result of -12:34:56:78. -+ -``` -SELECT (-12345678) (FORMAT '-99:99:99:99') FROM (VALUES(1)) t; -``` - <<< [[sample_clause]] == SAMPLE Clause