Subtractiong DATETIMES in 7.1 SPL

jthuex · #1 (**permalink**) 11-28-05, 09:17

Hi Folks,

I know it's stupid and I thought I understood it, but it looks otherwise:

CREATE PROCEDURE xt_test() RETURNING DATETIME YEAR TO SECOND;
DEFINE d1 DATETIME YEAR TO SECOND;
DEFINE d2 DATETIME YEAR TO SECOND;
DEFINE d3 INTERVAL DAY TO SECOND;
LET d1 = '2005-11-27 10:00:00';
LET d2 = '2005-11-27 11:00:00';
LET d3 = d2 - d1;
RETURN d3;
END PROCEDURE;
EXECUTE PROCEDURE xt_test();

results in:

SQL Error (-1260): It is not possible to convert between the specified types.

Do I have to rescale the INTERVAL variable "d3" with "EXTEND" ... ? And if so - how?

tx,

Joachim

gurey · #2 (**permalink**) 11-28-05, 09:23

Hi,

Please define d3 as char(11).
Gustavo.

hbe · #3 (**permalink**) 11-30-05, 09:44

Hi,

The problem is :

....Returnning DATETIME......
AND d3 is define as INTERVAL. So when you return the value engine must convert interval to datetime. Solution is define d3 as interval.

jthuex · #4 (**permalink**) 11-30-05, 09:54

Quote:

Originally Posted by hbe

Solution is define d3 as interval.

Thank you.

Joachim

Internet Services

Web Development

Digital Marketing

Consumer Tech