Re: datetime field

From: "jh" <joshho@singnet.com.sg> > > 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 ?? I do. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com