Current time in a procedure ??!!

[problems]

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


--
Posted via [url]http://dbforums.com[/url]

[Jonathan Leffler]

problems wrote:

> 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 ?

Google is your friend. [url]http://groups.google.com/[/url]

Suitable keywords: current time procedure
Optional extras: dbinfo sysshmvals

You can probably limit the date range to this year - certainly this
century.

--
Jonathan Leffler #include <disclaimer.h>
Email: [email]jleffler@earthlink.net[/email], [email]jleffler@us.ibm.com[/email]
Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

[rkusenet]

"problems" <member46368@dbforums.com> wrote in message news:3540871.1067526000@dbforums.com...

>
> 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 ?
>

create this function in sysmaster database and use it in your SP.

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 ;

GRANT EXECUTE ON dba.fn_getcurrtime TO public ;

[problems]

those solutions don't work !



it seems that I can't have the current time in a statement even if I
call an other function. The current time stop at the begening of a
procedure. How can i get the OS time in an informix function ???


--
Posted via [url]http://dbforums.com[/url]

[Alexey Sonkin]

You are wrong:

select DBINFO('utc_to_datetime',sh_curtime)
into end_time
from sysmaster:'informix'.sysshmvals;

works perfectly from SP, if 1 second accuracy is enough

------------------------------------------
Alexey Sonkin
Senior Database Administrator

> -----Original Message-----
> From: problems [mailto:member46368@dbforums.com]
> Sent: Monday, November 03, 2003 10:30 AM
> To: [email]informix-list@iiug.org[/email]
> Subject: Re: Current time in a procedure ??!!
>
>
> those solutions don't work !
>
>
>
> it seems that I can't have the current time in a statement even if I
> call an other function. The current time stop at the begening of a
> procedure. How can i get the OS time in an informix function ???
>
>
> --
> Posted via [url]http://dbforums.com[/url]

sending to informix-list