By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

calculating elapsed time of script

P: 5
I writing a Linux db2 udb sql script, not procedure, and one of the things that I would like to add is the elapsed time that the script runs. I'm having trouble defining start_time, end_time and elapsed_time. Start and end times should be from current time. Any help would be appreciated.
Feb 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: 5
ok, I got the start and end times defined by
[code] select time(current timestamp) as start_time from sysibm.sysdummy1 [code]

now how does one do elapsed time, difference between end and start times?
Feb 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.