Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Difference between two timestamps

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
Deepatinfy

New User


Joined: 06 Jun 2005
Posts: 7
PostPosted: Wed Jul 06, 2005 11:56 am    Post subject: Difference between two timestamps
 Reply with quote
Hi all,

How can i find the difference between two timestamps with out using the TIMESTAMPDIFF function?

TIA,
Deepesh
Back to top
View user's profile Send private message
References
kvivek

Active User


Joined: 09 May 2005
Posts: 51
Location: Singapore
PostPosted: Wed Jul 13, 2005 9:58 pm    Post subject:
Reply with quote
Code:
SELECT TIMESTAMP(TS1) - TIMESTAMP(TS2) FROM SYSIBM.SYSDUMMY1

Regards,
Vivek
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1