Re: displaying date/time in sql

Hi Trish, With certain versions of Unix, there are commands like "time", "timex", etc. So you could write something like : time isql -qr queryname > results.out .. or something like that. Not sure if I've got the syntax right. Hope that helps .... Paul. trish mcelvaney (trish@paragon.ie) wrote: : 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. -- ============================================================================= Paul Harrington Phone : +353-1-8740222 AIB Capital Markets Fax : +353-1-6707495 IFSC,Dublin. Email : paulh@iol.ie Any opinions expressed here are my own. =============================================================================