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)
