Re: displaying date/time in sql

Trish, There is a way to do this in ISQL, something like "select CURRENT datetime", not absolutely sure, so check out the manual. If you are using UNIX, the command "date" returns the current date and time, so an executable file like the one below would give you what you want: date isql "database-name" "query-name" date would do the same thing, and it is much easier. Cheers, Richard. ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | ----------------------------------------------------------------- ----- Begin Included Message ----- From ilist@rmy.emory.edu Tue Aug 29 16:17:40 1995 From: trish mcelvaney <trish@paragon.ie> To: informix-list@rmy.emory.edu Subject: displaying date/time in sql Date: Tue, 29 Aug 95 12:43:49 gmt X-Informix-List-To: rt10hp@csl.gov.uk X-Informix-List-Id: <list.7346> 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. ----- End Included Message -----