Re: displaying date/time in SQL

Trish, You might try adding the following statement before and after your test select: SELECT current FROM systables WHERE tabid = 1 The "SELECT current" portion will return the current time. The "FROM systables..." is a trick used to select the time once and only once. That's the good news. The bad news is that this will probably only give you a granularity of 1 second. In OnLine, if you have the parameter USEOSTIME set to 0, then the current time will never have a fractional value. So, try the statement a few times and see what you get. --Craig (craig@chemistry.utah.edu) > > 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. >