Subject Re: [firebird-support] ???HELP ---- CURRENT_TIME - PRINTS THE SAME TIME IN THE LOOP
Author Dimitry Sibiryakov
On 17 Jan 2006 at 10:59, kapilpatil84firebird wrote:

>Following is just the demo SP used to display the current time in a
>loop. But the problem is that each time, output prints the same time.

And this is quite documented, standard-compliant feature. Use
CAST("NOW" AS TIMESTAMP).

--
SY, Dimitry Sibiryakov.