RE: datetime field

>===== 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. >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com 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. I might actually admit to agreeing with him if that is what he thinks. Then again, guessing what a clown is thinking can be a dangerous thing. Will ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------