Re: Use sql to calculate a time difference between 2 records

Thanks for your reply Charles
When I get time (the noise you hear is NOT a laughing Hyena, but me ) I'll
look at that
I was thinking that there wouldn't be anything easy in SQL, but there is no
harm in asking



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



Charles Wilt
<charles.wilt@gma
il.com> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

04/02/2010 04:44 Subject
PM Re: Use sql to calculate a time
difference between 2 records

Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






You can do it with straight SQL but it'd be ugly...

RPG would be a good choice
A decent SQL based report writer would also work

Otherwise, consider building a UDF that makes use of the scratchpad to
calculate the difference. Here's an example of using the scratchpad
http://www.itjungle.com/fhg/fhg121405-story01.html

HTH,
Charles



On Fri, Apr 2, 2010 at 3:08 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:

Afternoon everyone

I have a non-keyed file that is in chronological order. The record

contains

a timestamp field.
How can I use SQL to determine the time difference (in seconds and parts

of

seconds) between one record and the next


As always any responses are MUCH appreciated

Thanks in advance



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.