Github user zellerh commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1656#discussion_r204970549
--- 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: +
--- End diff --
Since these values are generated, there won't be any invalid choices. Maybe
you could say "The following values are returned" instead?
---
