Subject Re: [firebird-support] tracking progress of a SP
Author Ivan Prenosil
> RR> Is there any way to get a real CURRENT_TIME from within a SP?
> Yes, use 'NOW' instead. Note that it is string literal, so you have to
> put single quotes around, like
> insert into tbl(DateTimeField) values('NOW');
> or
> DateTimeVar = 'NOW';

CURRENT_TIME and 'NOW' are precise to whole seconds only
(it should change in FB2), so perhaps some UDF would be better.
(e.g. getExactTimestamp() from fbudf)

Ivan