[
https://issues.apache.org/jira/browse/TRAFODION-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16554630#comment-16554630
]
ASF GitHub Bot commented on TRAFODION-3159:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1656#discussion_r204860831
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -9066,13 +9066,220 @@ second argument describes the format of the
character value.
TO_CHAR(character-expression [,format-string])
```
+[[to_char_syntax]]
+=== Syntax Description of TO_CHAR
+
* `_character-expression_`
+
is an expression that gives a datetime value.
* `_format-string_`
+
-is one of the following character string literals:
+.Details of `_format-string_`
+[cols="3*.^"]
+|===
+^| *Supported* `_character-expression_`
+^| *`_format-string_`*
+^| *Description*
+
+a| * `_datetime-expression_`
+** DATE
+** TIMESTAMP
+| 'CC'
+| Two-digital century.
--- End diff --
"Two-digit century" would be better.
> Add *Syntax Descriptions and Examples* for *TO_CHAR Function* in *Trafodion
> SQL Reference Manual*
> -------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-3159
> URL: https://issues.apache.org/jira/browse/TRAFODION-3159
> 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)
