Repository: trafodion Updated Branches: refs/heads/master c1aa0e6f4 -> 97098087a
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/97098087 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/97098087 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/97098087 Branch: refs/heads/master Commit: 97098087a5092e32b7c6a3b2216b31da4d915e82 Parents: 28c67bc Author: liu.yu <qwerty...@hotmail.com> Authored: Thu Aug 9 11:59:36 2018 +0800 Committer: liu.yu <qwerty...@hotmail.com> Committed: Fri Aug 10 11:55:23 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_clauses.adoc | 24 -------------------- 1 file changed, 24 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/97098087/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