RE: datetime field

Jonathan pointed out to me offline that there's something called DBINFO("utc_current") that might offer a solution. <Sigh> Guess I have toread a manual again... But it does beg the question: if there *is* a way of doing it, why doesn't CURRENT work as expected? From: Henry Benoit <Benoit.Henry@Galvalange.lu> > >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 > > > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com