[TRAFODION-2582] Two timestamp minus and cannot cast to interval value

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1-incubating
• Fix Version/s: any
• Component/s: sql-cmp
• Assignee: Anoop Sharma
• Reporter: Yuan Liu
• Created: 06/Apr/17 02:17
• Updated: 06/Apr/17 05:01

Description

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.