[ https://issues.apache.org/jira/browse/TRAFODION-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16555014#comment-16555014 ]
ASF GitHub Bot commented on TRAFODION-3159: ------------------------------------------- Github user liuyu000 commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1656#discussion_r204962653 --- 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. + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'D' +| Day of week (1-7), where 1 is Sunday, 6 is Saturday. + +This is not configurable. + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'DD' +| Day of month (01-31). + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'DDD' +| Day of year (001-366). + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'DY' +a| Name of day, which is a three-letter abbreviation for the day in uppercase. + + +Following values are valid: + --- End diff -- Thanks Dave, I've corrected 😁 > 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)