0 - 1 of 1 tags for 6758

Hello,

When I execute a query using the SUBSTRING function, it executes fine in SQL Assistant but when I port it over to a macro it errors out:

"6758: Invalid Time"

Here's a simple setup to see what I mean:

DROP TABLE FP_BUSHOUR_REF;

CREATE SET TABLE FP_BUSHOUR_REF
(
FixedperiodId DECIMAL(10,0) NOT NULL,
Bushour SMALLINT,
Fp_Num SMALLINT,
Fp_start VARCHAR(20),
Fp_End VARCHAR(20))
UNIQUE PRIMARY INDEX ( FixedperiodId );

INSERT INTO fp_bushour_ref (96,18,73,'18:00','18:14:59');