[
https://issues.apache.org/jira/browse/TRAFODION-3001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16409120#comment-16409120
]
ASF GitHub Bot commented on TRAFODION-3001:
-------------------------------------------
Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1486#discussion_r176318566
--- 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 --
@DaveBirdsall Thanks for your correction, I've changed "NUMERIC VALUE" to
"NUMERIC".
> Add an Overview of *Datetime Functions* in *Trafodion SQL Reference Manual*
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-3001
> URL: https://issues.apache.org/jira/browse/TRAFODION-3001
> 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)
