You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/12/15 00:20:03 UTC
[2/4] incubator-trafodion git commit: Rework addressing Ming's
comments
Rework addressing Ming's comments
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/05640f11
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/05640f11
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/05640f11
Branch: refs/heads/master
Commit: 05640f11cee3c9487c6db93322db37a2d7f524ab
Parents: 88f4a8b
Author: Dave Birdsall <db...@apache.org>
Authored: Fri Dec 9 01:17:19 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Fri Dec 9 01:17:19 2016 +0000
----------------------------------------------------------------------
.../_chapters/sql_functions_and_expressions.adoc | 14 +++++++++++++-
1 file changed, 13 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/05640f11/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
index a99a0cb..5bbecf4 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
@@ -7561,6 +7561,10 @@ is one of the following character string literals:
** 'DD-MON-YYYY'
** 'DDMONYYYY'
+Here, YYYY refers to a 4-digit year. YY refers to a two-digit year. MM refers to a two-digit month. MON refers to
+a three-letter abbreviation for month ('JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP',
+'OCT', 'NOV' or 'DEC'). The month may be given in lower case, upper case or any mixture.
+
If the _format-string_ argument is omitted, 'YYYY-MM-DD' is used as the
default.
@@ -7615,6 +7619,12 @@ is one of the following character string literals:
** 'MONTH DD, YYYY, HH:MI'
** 'DD.MM.YYYY HH24.MI.SS'
+Here, YYYY refers to a 4-digit year. YY refers to a two-digit year. MM refers to a two-digit month. MON refers to
+a three-letter abbreviation for month ('JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP',
+'OCT', 'NOV' or 'DEC'). MONTH refers to the month spelled out. The month in either MON or MONTH form may be given in lower case, upper case or any mixture.
+
+HH and HH24 refer to a 2-digit hour field. MI refers to a two-digit minutes field. SS refers to a 2-digit seconds field.
+
[[considerations_for_to_time]]
=== Considerations for TO_TIME
@@ -7648,7 +7658,9 @@ TO_TIMESTAMP(character-expression)
* `_character-expression_`
+
-is an expression that gives a character value.
+is an expression that gives a character value. The expression ia assumed to have the format YYYY-MM-DD HH:MI:SS[.FFFFFFF],
+where YYYY is a 4-digit year, MM is a 2-digit month, DD is a 2-digit day, HH is a 2-digit hours field, MI is a 2-digit
+minutes field, SS is a two-digit seconds field and FFFFFF is an optional microseconds field.
[[examples_of_to_timestamp]]
=== Example of TO_TIMESTAMP