On Fri, Feb 6, 2009 at 3:59 AM, Helen Borrie <helebor@...> wrote:

>
> Old InterBase versions used to convert datetime literals in a fairly
> unreliable manner. It got cleaned up at v.6 and you need to cast time
> literals in a lot of places where IB 5 and lower didn't require it.

Now, that is strange. I have tried the following code in Firebird
2.1.1 on Linux and I get it to run successfully.

---------------------------------- begin code
---------------------------------------------------
CREATE or alter PROCEDURE TP returns (Endtime TIME)

AS

DECLARE VARIABLE Starttime TIME;

begin

StartTime = '08:00';

EndTime = StartTime;
suspend;
end
---------------------------------- end code
-------------------------------------------

Is this supposed to be a bug? Shouldn't I have to cast the string to a
time just as you described?

Fidel.