You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "chenyunren (JIRA)" <ji...@apache.org> on 2018/07/18 05:06:00 UTC

[jira] [Created] (TRAFODION-3150) to_char and extract function's new options bug

chenyunren created TRAFODION-3150:
-------------------------------------

             Summary: 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


1.select extract(quarter from interval '99' month) from dual;

return:33

should return 2

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)