[ https://issues.apache.org/jira/browse/TRAFODION-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16295945#comment-16295945 ]
ASF GitHub Bot commented on TRAFODION-2849: ------------------------------------------- Github user DaveBirdsall commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/1350#discussion_r157638866 --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc --- @@ -3679,40 +3863,43 @@ EXTRACT (YEAR FROM INTERVAL '01-09' YEAR TO MONTH) + The result is 1. - <<< -[[hour_function]] -=== HOUR Function +[[filetolob_function]] +== FILETOLOB Function -The HOUR function converts a TIME or TIMESTAMP expression into an -INTEGER value in the range 0 through 23 that represents the -corresponding hour of the day. +[[filetolob_function_syntax]] +=== Syntax Descriptions of FILETOLOB Function -HOUR is a {project-name} SQL extension. +The FILETOLOB function converts data from a local linux/hdfs file into LOB format. This function can be used in INSERT or UPDATE statement. --- End diff -- same comment as before > Add BLOB and CLOB for *Trafodion SQL Reference Manual* > ------------------------------------------------------ > > Key: TRAFODION-2849 > URL: https://issues.apache.org/jira/browse/TRAFODION-2849 > Project: Apache Trafodion > Issue Type: Documentation > Reporter: Liu Yu > Assignee: Liu Yu > -- This message was sent by Atlassian JIRA (v6.4.14#64029)