[ https://issues.apache.org/jira/browse/TRAFODION-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16555930#comment-16555930 ]
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_r205178175 --- 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 returned: + + +* 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 returned: + + +* 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 returned: + + +* JAN + + +* FEB + + +* MAR + + +* APR + + +* MAY + + +* JUN + + +* JUL + + +* AUG + + +* SEP + + +* OCT + + +* NOV + + +* DEC + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'Q' +| Quarter (1-4). + +a| * `_datetime-expression_` +** TIME +** TIMESTAMP +| 'SS' +| Second (00-59). + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'W' +| Week of month. + +a| * `_datetime-expression_` +** DATE +** TIMESTAMP +| 'WW' +a| Week of year. + + +* The value 1 is returned for datetime that occurs in the first 7 days of the year if the year begins on Sunday. + --- End diff -- "for a datetime" would be better (here and below) > 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)