[ https://issues.apache.org/jira/browse/TRAFODION-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16555150#comment-16555150 ]
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_r204984589 --- 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-digit 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. + + +The following values are valid: + + +* MON + + +* TUE + + +* WED + + +* THU + + +* FRI + + +* SAT + + +* SUN + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'DAY' +a| Name of day, which is full uppercase day name padded with blanks to the length of 9 characters. + + +The following values are valid: + + +* MONDAY + + +* TUESDAY + + +* WEDSDAY + + +* THURSDAY + + +* FRIDAY + + +* SATURDAY + + +* SUNDAY + +a| * `_datetime-expression_` +** TIME +** TIMESTAMP +| 'HH' +| Hour of day in 24-hour format (00-23). + +'HH' behaves the same as 'HH24'. + +a| * `_datetime-expression_` +** TIME +** TIMESTAMP +| 'HH12' +| Hour of day in 12-hour format (01-12). + +a| * `_datetime-expression_` +** TIME +** TIMESTAMP +| 'HH24' +| Hour of day in 24-hour format (00-23). + +'HH24' behaves the same as 'HH'. + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'J' +| Julian date (that is, number of days since January 1, 4713 BC). + +a| * `_datetime-expression_` +** TIME +** TIMESTAMP +| 'MI' +| Minute (00-59). + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'MM' +| Month (01-12). + + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'MON' +a| Month, which is a three-letter abbreviation for the month in uppercase. + + +The following values are valid: + --- End diff -- Vielen Dank, Ich habe den Fehler korrigiert 😁 > 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)