Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1695#discussion_r210705551
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---
@@ -776,14 +776,105 @@ 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_)]`
+
++
+** specifies a datetime column that, without the optional
--- End diff --
The wording of this paragraph is a bit awkward. Possible wordsmith: "**
specifies a datetime column. If `_timestamp-precision_` is specified and is
zero, the timestamp in external form is `yyyy-mm-dd hh:mm:ss` and the database
storage is 7 bytes. In all other cases, the timestamp in external form is
`yyyy-mm-dd hh:mm:ss.ffffff`, the number of digits to the right of the decimal
point being equal to `_timestamp-precision_`. If `_timestamp-precision_` is
omitted, it defaults to six. Database storage is 11 bytes in these cases.
---
