[
https://issues.apache.org/jira/browse/TRAFODION-2394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15771246#comment-15771246
]
ASF GitHub Bot commented on TRAFODION-2394:
-------------------------------------------
GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/incubator-trafodion/pull/890
[TRAFODION-2394] Add documentation for TO_CHAR + fix some bugs in it
This set of changes does the following:
1. Adds documentation for the TO_CHAR function to the SQL Reference Manual.
2. Fixes four bugs:
a. TO_CHAR(x), where x is a TIME column, would sometimes have garbage
characters at the end of it. This has been fixed.
b. TO_CHAR(x,'YY/MM/DD') produces garbage output when x is a TIME column,
because x has no date fields. This has been fixed. A 4072 error is now raised
instead.
c. TO_CHAR(DATE '2016-03-01', 'YYYYMMDDHH24MISS') returns an incorrectly
formatted value, '2016030100:00:'. This has been fixed; it now returns the
correct value '20160301000000'.
d. DATEFORMAT(5,USA) returns an error 4071 (as it should), but the error
message text says "TO_CHAR" instead of "DATEFORMAT". This has been fixed.
3. Updates to regression test seabase/TEST030 and its expected results to
cover the bugs above.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion2394
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/890.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #890
----
commit 93bd6bcd1c24c779a45af55bb31898a2f1f01e2f
Author: Dave Birdsall <[email protected]>
Date: 2016-12-22T22:10:04Z
[TRAFODION-2394] Add documentation for TO_CHAR + fix some bugs in it
----
> update sql reference manual about TO_CHAR function
> --------------------------------------------------
>
> Key: TRAFODION-2394
> URL: https://issues.apache.org/jira/browse/TRAFODION-2394
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: liu ming
> Assignee: David Wayne Birdsall
>
> need to add documentation about TO_CHAR function.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
