Tope Akinniyi wrote:

>
> ... this stored procedure:
> ...
> 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^
>
> On execution the column "THREE" that is supposed to contain the
>varying CURRENT_TIME values have the same time for all the 20000

records.

The SQL standard specifies that time stands still during a verb, and the
entire execution of a procedure is a single verb. What you want is
probably 'NOW', a special string like '12:00:00' that signifies a
specific time - to wit, now. It's not part of the standard.

Regards,


Ann