Hi,
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

hello,

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
date

it gives the system time for you.


-PD

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.

But, how can i get the OS time in an informix function ???

This works in 9.x

create function fn_getcurrtime() returns datetime year to second
define cur_time datetime year to second;
select DBINFO('utc_to_datetime',sh_curtime)
into cur_time
from sysmaster:sysshmvals;
return cur_time ;
end function ;