try

insert into first(one,two,three) values('tt','12:00:00','now');

----- Original Message -----
From: "Tope Akinniyi" <topeakinniyi@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, March 29, 2005 2:00 PM
Subject: [firebird-support] CURRENT_TIME


>
> Hi,
>
> I have this table schema for a test:
>
> CREATE TABLE "FIRST"
> (
> "ONE" VARCHAR(20),
> "TWO" TIME,
> "THREE" TIME,
> "FOUR" COMPUTED BY (three-two)
> );
>
> and this stored procedure:
>
> SET TERM ^ ;
> ALTER PROCEDURE FIRST1
> AS
> DECLARE VARIABLE i INTEGER;
> BEGIN
> i=0;
> WHILE (i<20000) DO
> BEGIN
> insert into first(one,two,three) values('tt','12:00:00',CURRENT_TIME);
> i=i+1;
> END
> END^
> SET TERM ; ^
>
> On execution the column "THREE" that is supposed to contain the varing
> CURRENT_TIME values have the same time for all the 20000 records. What am
> I doing wrong?
>
> Thanks for your enlightenment.
>
>
>
> -------
> Best regards,
>
> Tope Akinniyi
> CEO
> ShepherdHill Software
> Lagos, Nigeria
>
> Do not forget: Jesus said, I am the way, the truth and the life.
>
> Send instant messages to your online friends http://uk.messenger.yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>