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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.