Re: [sqr-users] SQR run time

[Don Mellen <donm@ontko.com>]

On Wed, 23 Apr 2003, [iso-8859-1] Christophe CHOUX wrote:

> 
> why you doesn't want to use sysdate ... it works very well ... for every 
>procedure if you want ;-)
>  Ashish Bhatt <ashish_bhatt@hotmail.com> wrote:Hi All SQR Gurus,
> 
> I hope you are doing fine today.
> 
> I want to display on UNIX screen my sqr start time and end time.
> 
> Is there any easy way to do this using call to some sqc function ?

If you want to remain database independent, and ate on SQR 4.0 or above,
you can use the value of the reserved date variable "$current-date" as the
start time, and the "datenow()" function at the end of the run.  Remember
that these are/return dates and must be formatted to show time, something
like....

   show 'Start Time: ' $current-date edit 'HH24:MI:SS'
   ... rest of program ...
   let $end = datetostr(datenow(),'HH24:MI:SS')
   show 'Completed : ' $end

Of course, on longer programs, you may want to include the day, month, and
year in the format for start and end.     ;)

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users