[ https://issues.apache.org/jira/browse/TRAFODION-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anoop Sharma reassigned TRAFODION-2582: --------------------------------------- Assignee: Anoop Sharma (was: 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: Anoop Sharma > 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)