Subject | Re: how can i get the sql code of the current executed statement |
---|---|
Author | unordained |
Post date | 2010-11-18T15:37:35Z |
---------- Original Message -----------
From: Helen Borrie <helebor@...>
Is this UDF any more precise than the 2.x millisecond support, which seems to
have a granularity of about 15ms? I don't care for the purpose of absolute
timestamps, just for relative intervals, timing how long it takes to do stuff
(inside SPs/triggers).
Hmmm. http://msdn.microsoft.com/en-us/library/ms644904(VS.85).aspx is probably
what I'm looking for, and that looks like something I'd want to handle in another
custom UDF. So ... nevermind?
-Philip
From: Helen Borrie <helebor@...>
> > > Is there way to get the current time with millisecond precision.------- End of Original Message -------
> > Write custom UDF or upgrade to FB 2.x.
> Or use the UDF 'getExactTimestamp' and correct the result to milliseconds.
>
> declare external function getExactTimestamp
> timestamp /* has ten-thousandths of a second accuracy in v.1.5 */
> returns parameter 1
> entry_point 'getExactTimestamp' module_name 'fbudf';
Is this UDF any more precise than the 2.x millisecond support, which seems to
have a granularity of about 15ms? I don't care for the purpose of absolute
timestamps, just for relative intervals, timing how long it takes to do stuff
(inside SPs/triggers).
Hmmm. http://msdn.microsoft.com/en-us/library/ms644904(VS.85).aspx is probably
what I'm looking for, and that looks like something I'd want to handle in another
custom UDF. So ... nevermind?
-Philip