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: 7315

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 Comparing 2 Files using Current time arunsoods DFSORT/ICETOOL 2 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 5 Sat May 06, 2017 12:59 am
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm

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