RE: datetime field

From: William Rice <ricew@operamail.com> > > >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> >===== > >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. > >Obnoxio probably thinks it is because the value of current is assigned >when the stored procedure starts and not reevaluated later on in the >stored procedure. That may well be the case. >I might actually admit to agreeing with him if that is what he thinks. Hope it doesn't make you too uncomfortable. >Then again, guessing what a clown is thinking can be a dangerous thing. Actually, I started thinking about how dumb it was that you can't time a stored procedure. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com