datetime field
Posted in 2000
jh — — source: Informix-list mailing list archive (1991-1998)
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