Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Is there a time Version of DATEDIFF ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Steve Ironmonger

New User


Joined: 19 Oct 2015
Posts: 15
Location: UK

PostPosted: Wed Aug 17, 2016 7:06 pm    Post subject: Is there a time Version of DATEDIFF ?
Reply with quote

Just wondering if this is possible.

I'm trying to calculate the difference between two times (i've created the times in a REXX so I can format them any way I want)

Basically my data looks like this

Code:

Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28


I want to calculate the difference between the 2 times and create a file that contains the following :-

Code:

Cust Num,Date,Start Time,End Time
000000426,20160802,16:54:30,0009,17:02:28,00:07:58


I.e. the difference between the end time and the start time

I can do what I want in excel or in the rexx, I'd rather not do it in the rexx as the job is going to run daily and there will be several 100,000 records to process and I don't want capacity & performance on my back about how much CPU my job is using !

Any help or ideas would be greatly appreciated.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Aug 17, 2016 10:45 pm    Post subject: Reply to: Is there a time Version of DATEDIFF ?
Reply with quote

No end date? Jobs running for longer than 24 hours will be incorrect.

Jobs starting before midnight, ending after midnight complicate things. Identical start and end times could occur? Would they be less than one second, or exactly 24 hours?

If you can do seconds since midnight in your Rexx, it would make things easier. You'd still have some calculation to get hours and minutes.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Merging records, but not all the time prino DFSORT/ICETOOL 15 Sat Feb 17, 2018 4:20 pm
No new posts Need to identify top 10 costly or tim... ashek15 DB2 4 Wed Feb 14, 2018 3:20 am
No new posts Logic to skip Maximum time-stamp and ... vickey_dw DB2 2 Thu Feb 01, 2018 11:15 pm
No new posts Query to skip Max time-stamp and fetc... vickey_dw DB2 8 Sun Jan 28, 2018 1:09 am
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us