[
https://issues.apache.org/jira/browse/TRAFODION-3184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16582952#comment-16582952
]
ASF GitHub Bot commented on TRAFODION-3184:
-------------------------------------------
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.
> Correct Syntax Descriptions and Add Examples for *TIME* and *TIMESTAMP(P)* in
> *Trafodion SQL Reference Manual*
> --------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-3184
> URL: https://issues.apache.org/jira/browse/TRAFODION-3184
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
