Subject Re: [firebird-support] TIME datatype
Author Vlad Khorsun
>I have worked with Firebird / Interbase for about 12 years now and I must
> admit I am stumped. I am writing a stored procedure that uses =93TIME=94
> fields. I want to initialize a begin and end time and I keep getting
> errors. I wrote as simple a stored procedure as I could to illustrate the
> problem. I am setting up a StartTime and need to add an hour to the time
> and store as an end time. I cannot get it to work and here is an example o=
> f
> just setting EndTime =3D StartTime. I am using Firebird V1.5.5.4926.
>
> =20
>
> What am I missing here?
>
> =20
>
> =20
>
> CREATE PROCEDURE TP=20
>
> AS
>
> DECLARE VARIABLE Starttime TIME;
>
> DECLARE VARIABLE Endtime TIME;
>
> begin
>
> StartTime =3D '08:00';
>
> EndTime =3D StartTime; =DF error occurs on this

What error ? Why do you think it occurs at this line ?

Regards,
Vlad