Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1486#discussion_r176224418
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -150,67 +150,109 @@ See the individual entry for the function.
== Datetime Functions
These functions use either a datetime value expression as an argument or
-return a result of datetime data type:
+return a result of DATETIME, VALUE or CHAR:
-[cols="25%,75%"]
+[caption="Table 7-3 "]
+.Overview of DATETIME Functions
+[cols="25%,50%,25%"]
|===
+| *Name* | *Description* | *Return Data Type*
| <<add_months_function,ADD_MONTHS Function>>
| Adds the integer number of months specified by _intr_expr_
to _datetime_expr_ and normalizes the result.
+| DATE
| <<converttimestamp_function,CONVERTTIMESTAMP Function>>
| Converts a Julian timestamp to a TIMESTAMP value.
+| TIMESTAMP
| <<current_function,CURRENT Function>> | Returns the current timestamp.
You can also use the
<<current_timestamp_function,CURRENT_TIMESTAMP Function>>.
+| TIMESTAMP
| <<current_date_function,CURRENT_DATE Function>>
| Returns the current date.
+| DATE
| <<current_time_function,CURRENT_TIME Function>>
| Returns the current time.
+| TIME
| <<current_timestamp_function,CURRENT_TIMESTAMP Function>> | Returns the
current timestamp. You can also use the <<current_function,CURRENT Function>>.
+| TIMESTAMP
| <<date_add_function,DATE_ADD Function>>
| Adds the interval specified by _interval_expression_
to _datetime_expr_.
+| DATE
| <<date_part_function_of_an_interval,DATE_PART Function (of an
Interval)>> | Extracts the datetime field specified by _text_ from the interval
value
specified by interval and returns the result as an exact numeric value.
+| NUMERIC VALUE
--- End diff --
Not sure why we say "NUMERIC VALUE" instead of just "NUMERIC". A function
that returns a DATE also returns a value; the value just happens to be a DATE.
Though I suppose we could make a case for "NUMERIC VALUE" if we reason that
"NUMERIC" is an adjective but not a noun. I would buy that.
---
