Subject | Re: [firebird-support] tracking progress of a SP |
---|---|
Author | Ivan Prenosil |
Post date | 2005-03-21T13:19:30Z |
> RR> Is there any way to get a real CURRENT_TIME from within a SP?CURRENT_TIME and 'NOW' are precise to whole seconds only
> 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';
(it should change in FB2), so perhaps some UDF would be better.
(e.g. getExactTimestamp() from fbudf)
Ivan