[jira] [Created] (TRAFODION-2582) Two timestamp minus and cannot cast to interval value

[Yuan Liu (JIRA)]

Yuan Liu created TRAFODION-2582:
-----------------------------------

             Summary: 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: Build Infrastructure
    Affects Versions: 2.1-incubating
            Reporter: Yuan Liu
             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)