Re: displaying date/time in sql

Hi, If you're running isql (or dbaccess?) in one of the modes: isql dbase script isql - script isql dbase - isql - - then it allows you to use ! to do shell escapes: eg "!date" to execute the date command, and "!ls" to execute ls, etc. Otherwise, No, not with the standard tools. I have an SQL command interpreter SQLCMD which does allow you to do timings at whatever resolution is available -- nanoseconds if you have POSIX.4 type timers. That's a lot of source code, and it isn't in a very portable state at the moment. I could make a development version available to you, but you'd have to sort out most of the porting problems. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: trish mcelvaney <trish@paragon.ie> >Date: Tue, 29 Aug 95 12:43:49 gmt >X-Informix-List-Id: <list.7346> > >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.