RE: datetime field
CURRENT is fixed in a stored procedure. I expect you'd need to
do some sort of system call if you really need the current time.
> 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