var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: current time in procedure
i want to put a lot of trace (log time in a table) in some procedure. The function "current" show the same time by statement. How can i get the real current time in a procedure ?
please help me
Couple of ways,
select first 1 current from tabname.
have this as dummy table with 1 row, or any table with minimum no. of rows.
second, write a 1 line .sh file with a line
it gives the system time for you.
The timestamp you will retrieve is the timestamp when you first entered the stored procedure - it doesn't change while in the SP.
That being said, you have to query the OS for the current time.
how can i get the OS current time
But, how can i get the OS time in an informix function ???
Re: how can i get the OS current time
This works in 9.x
create function fn_getcurrtime() returns datetime year to second
define cur_time datetime year to second;
return cur_time ;
end function ;