[ 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 <jupiter3019@...> 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)