values(current timestamp)
or
select current timestamp from sysibm.sysdummy1

Alternatively, you can use db2batch command which will show you the time
taken to execute the query plus few other useful information ...

HTH

Sathyaram
www.db2click.com <http://www.db2click.com>
http://www.idug.org/forums/UserForumHome.asp
<http://www.idug.org/forums/UserForumHome.asp>

-----Original Message-----
From: anindya
[Email address protected]
Sent: Mon 17/05/2004 21:34
To: LazyDBA Discussion
Cc:
Subject: How to find DB2 Timestamp Command



Hi All,
Do you suggest and Command which will give the present timestamp of
the server? I would like to use that command before and after the Long
query to find out the time taken by the Query. I know there is Date() and
Timestamp() Functions. But these are not commands which will serve my
purpose.
For example the format would be...

<command to get present time stamp>
<My Query to execute>
<command to get present time stamp again>

Any Idea???

Thank you all.




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com <http://www.LazyDBA.com>
To unsubscribe, e-mail: [Email address protected]
For additional commands, e-mail: [Email address protected]


**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



DB2 & UDB email list listserv db2-l LazyDBA home page