[SQL] Now() in a function

[sTesting]

Hi,
 
I have a big problem, i wrote a very long function 
that is taking so much time. inside this function i added few debugging steps to 
find which section is taking most of the time, but all the created records have 
the same time in them, the time where the fuction begins.
I tried to different methods:

INSERT INTO f_error (error_id, 
creation_date)VALUES (nextval(''s_f_error_id''), now());
 

INSERT INTO f_error (error_id, 
creation_date)VALUES (nextval(''s_f_error_id''), ''now'');
 
Tanks in advance for your help.

Re: [SQL] Now() in a function

[Gaetano Mendola]

sTesting wrote:

Hi,
 
I have a big problem, i wrote a very long function that is taking so 
much time. inside this function i added few debugging steps to find 
which section is taking most of the time, but all the created records 
have the same time in them, the time where the fuction begins.
I tried to different methods:
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), now());
 
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), ''now'');
now() give you the time when the transaction started,
so what you see is the intended behavior, in your case you must use:
timeofday().
Regards
Gaetano Mendola
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings