Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1656#discussion_r204862408
--- 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: +
+
+* 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. +
+
+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'
+| Number of days since Julian date (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.
+
+
+Following values are valid: +
--- End diff --
Suggested wordsmith: "The following values are valid: +"
---
