Subject | Re: [firebird-support] TIME datatype |
---|---|
Author | Vlad Khorsun |
Post date | 2009-02-06T15:21:37Z |
>I have worked with Firebird / Interbase for about 12 years now and I mustWhat error ? Why do you think it occurs at this line ?
> 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
Regards,
Vlad