[
https://issues.apache.org/jira/browse/TRAFODION-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller reassigned TRAFODION-2582:
--------------------------------------
Assignee: Hans Zeller
> Two timestamp minus and cannot cast to interval value
> -----------------------------------------------------
>
> Key: TRAFODION-2582
> URL: https://issues.apache.org/jira/browse/TRAFODION-2582
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 2.1-incubating
> Reporter: Yuan Liu
> Assignee: Hans Zeller
> Fix For: any
>
>
> SQL>select cast((timestamp'2017-04-06 11:50:00' - timestamp'2017-04-06
> 11:45:00') as interval second) from (values(1));
> (EXPR)
> ----------
> 0.000000
> --- 1 row(s) selected.
> SQL>select cast((timestamp'2017-04-06 11:50:00' - timestamp'2017-04-06
> 11:45:00') as interval minute) from (values(1));
> (EXPR)
> ------
> 0
> >>select timestamp'2017-04-06 11:50:00' - timestamp'2017-04-03 11:45:00' from
> >>dual;
> (EXPR)
> -------------
> 3
> --- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
