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

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.