We want to now the execution time of some nightly stored procedure.
Our test :
define now1 datetime year to fraction ;
define now2 datetime year to fraction ;

select current into now1 from systables where tabid = 1;
system "sleep 20"
select current into now2 from systables where tabid = 1;

While we're expecting an interval, both datetime are equal.

The same result if the SP calls another SP which return the time.
Of course our scheduler could do it, but it would be nicer in the SP.

informix 7.31 aix 4.3
Someone knows an elegant workaround ?
Thanks,

Yves

Try this - I believe it will work with IDS 7.31:

SELECT DBINFO('utc_to_datetime', sh_curtime) AS CURRENT
FROM sysmaster:sysshmvals;

Ok thanks,
that's wat I'm looking for.
Have a nice day.