You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/07/18 07:34:00 UTC
[jira] [Commented] (TRAFODION-3150) to_char and extract function's
new options bug
[ https://issues.apache.org/jira/browse/TRAFODION-3150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16547488#comment-16547488 ]
ASF GitHub Bot commented on TRAFODION-3150:
-------------------------------------------
GitHub user kakaxi3019 opened a pull request:
https://github.com/apache/trafodion/pull/1651
[TRAFODION-3150] fix to_char & extract bugs
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/kakaxi3019/trafodion trafodion-3150
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1651.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 #1651
----
commit b51ec2189126e123b1cddf287536109f92334af8
Author: kakaxi3019 <ju...@...>
Date: 2018-07-18T07:29:09Z
fix to_char&extract bugs
----
> to_char and extract function's new options bug
> ----------------------------------------------
>
> Key: TRAFODION-3150
> URL: https://issues.apache.org/jira/browse/TRAFODION-3150
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: chenyunren
> Priority: Major
>
> 1.select extract(quarter from interval '99' month) from dual;
> return:33
> should return 1
> 2.select extract(week from date '2016-01-03') from dual;
> return:2
> should return 1
> 3.select to_char(date '2016-01-03','ww') from dual;
> return:2
> should return 1
> 4.select to_char(time '00:00:01', 'hh12') from dual;
> return:00
> should return 12
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)