Re: displaying date/time in sql
we do this all the time:
select current from systables where tabid=1;
sql that you want to time
select current from systables where tabid=1;
>
>
> Hello All,
>
> I am currently writing SELECT statements, and I want see how long
> they take to execute.
>
> Is there any way (in Sql) to display time, before, then display the
> time after the SELECT.
>
> Thanks for any help.
>
>
> Trish ---- Paragon, Dublin, Ireland.
>
>
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | rzbj40@email.sps.mot.com |
+----------------------------------------------------------------------------+