Incorporate Comments 1
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/75ff3c47 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/75ff3c47 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/75ff3c47 Branch: refs/heads/master Commit: 75ff3c47284ec9f75f2badc3d76778135e02ce6e Parents: 9f488ba Author: liu.yu <qwerty...@hotmail.com> Authored: Fri Aug 17 14:43:25 2018 +0800 Committer: liu.yu <qwerty...@hotmail.com> Committed: Fri Aug 17 14:43:25 2018 +0800 ---------------------------------------------------------------------- .../_chapters/sql_language_elements.adoc | 26 +++++++++++--------- 1 file changed, 14 insertions(+), 12 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/75ff3c47/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc index 495c80b..2868989 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc @@ -775,13 +775,12 @@ bytes. _time-precision_ is an unsigned integer that specifies the number of digits in the fractional seconds and is stored in four bytes. The default for _time-precision_ is 0, and the maximum is 6. -* `TIMESTAMP [(_timestamp-precision_)]` +* `TIMESTAMP` + -** specifies a datetime column that, without the optional -`_timestamp-precision_`, contains a timestamp in the external form -`yyyy-mm-dd hh:mm:ss` with the default precision of 6 even the -`_timestamp-precision_` is not specified, and it is stored in 11 bytes. +** specifies a datetime column. ++ +The timestamp in the external form is `yyyy-mm-dd hh:mm:ss.ffffff` *with the default precision of 6*, the storage size is 11 bytes. + *Example* @@ -818,18 +817,21 @@ CREATE TABLE TRAFODION.SEABASE.TEST1 --- SQL operation complete. ``` +* `TIMESTAMP (_timestamp-precision_)` + + -** specifies a datetime column that, with the `_timestamp-precision_`, -which is an unsigned integer that specifies the number of digits in the -fractional seconds. The range of `_timestamp-precision_` is from 0 to 9, -the storage size varies depending on the `_timestamp-precision_`. +specifies a datetime column with the `_timestamp-precision_`. ++ +The `_timestamp-precision_` is an unsigned integer that specifies the number of digits in the +fractional seconds, the range of `_timestamp-precision_` is from 0 to 9, the storage size varies depending +on the `_timestamp-precision_`. + -[cols="2*"] +[cols="2*^"] |=== | `_time-precision_` | Storage Size (bytes) -| 0 | 7 -| 1~9 | 11 +| 0 | 7 +| 1~9 | 11 |=== +