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 06:43:00 UTC
[jira] [Updated] (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:all-tabpanel ]
chenyunren updated TRAFODION-3150:
----------------------------------
Description:
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
was:
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
> 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)