Re: Create TimeStamp from numeric fields

Adam,
I will most likely end up doing that, but since the program I was working with did not use SQL, I did not want to introduce an added layer of complexity.

Thanks,
 
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
  
 






________________________________
From: Adam Glauser <adamglauser@xxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Sent: Wednesday, November 19, 2008 2:40:16 PM
Subject: Re: Create TimeStamp from numeric fields

Jeff Young wrote:

  have a record containing 2 fields containing a numeric representation of a date (8,2)  and 2 associated fields containing a numeric representation of an associated time (6,0).fields.

What I want to do is to get the difference between date/time 2  and date/time 1.

Is there an easy way to do this?

Probably, but it would help to know about more about the format of the
date.  Is it YYYYMM.DD, or is it some sort of epoch date?

On the other hand, why not use some SQL like the TIMESTAMPDIFF function
you were asking about on Midrange-L the other day?  You should be able
to adapt that solution to this problem fairly easily.