RE: datetime field
Hello,
Maybe you can use this approach :
-----
select current as _START_TIME_
from sysusers
where username='informix';
execute procedure abc ();....
select current as _STOP_TIME_
from sysusers
where username='informix';-----
Hope this help !
Benoit
> -----Original Message-----
> From: jh [SMTP:joshho@singnet.com.sg]
> Sent: Wednesday, March 01, 2000 11:23 AM
> To: informix-list@iiug.org
> Subject: datetime field
>
> Hi,
>
> I've tried running the following procedure :
>
> create procedure abc ()>
> define starttime datetime year to second;
> define endtime datetime year to second;
> define recordproc integer;
>
> let starttime=current;
> let recordproc=30;
>
> --call some stored procedures (it takes more than15 mins)
>
> let endtime=current;
>
> insert into recon_time
> (start_time, end_time, record_processed) values
> (starttime,endtime,recordproc);>
> end procedure;
>
> When I view from the recon_time table, the start_time and end_time are
> the
> same. Does anyone know why ??
>
> Regards
>
>
> Joshua
>
>
>