[
https://issues.apache.org/jira/browse/TRAFODION-3184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16582953#comment-16582953
]
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_r210709602
--- 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 --
Just noticed that you have a table below that gives the storage sizes. So
we don't even have to mention it in this paragraph. Possible revised 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. 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."
> 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)
