IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

To get difference of 2 timestamps
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
ArchanaKalwani

New User


Joined: 11 Aug 2008
Posts: 6
Location: India
PostPosted: Thu Aug 21, 2008 6:41 pm
 Reply with quote
Hi,

I need to take difference of 2 timestamps fields in DB2.

I have heard of something like TIMEDIFF which can be used.

Can anyone please share some documentation detailing the syntax, usage etc. for the same.

Any other option to get time difference will also be helpful.

Thanks,
Archana
Back to top
View user's profile Send private message
rpuhlman

New User


Joined: 11 Jun 2007
Posts: 80
Location: Columbus, Ohio
PostPosted: Thu Aug 21, 2008 10:13 pm
 Reply with quote
Archana,

Please refer to this link:

http://ibmmainframes.com/post-89441.html

Rick
Back to top
View user's profile Send private message
ArchanaKalwani

New User


Joined: 11 Aug 2008
Posts: 6
Location: India
PostPosted: Fri Aug 22, 2008 12:47 pm
 Reply with quote
Thanks a lot...
It was pretty simple... icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts What is the difference between Taskty... Compuware & Other Tools 2
No new posts Difference between VALIDPROC and CHEC... DB2 3
No new posts Difference between CEE3250C and CEE3204S COBOL Programming 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us