RE:Create TimeStamp from numeric fields

Jeff,
I have a procedure that I wrote back in 2004 that will take an 8 digit
numeric field and either a 4 or 6 digit time field and combine them to
create a timestamp field. You should be able to modify it to do what
you need. Let me know if you want it and I will send it to you off
list.


Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell 1.251.363.4975

------------------------------

message: 6
date: Wed, 19 Nov 2008 11:22:07 -0800 (PST)
from: Jeff Young <cooljeff913@xxxxxxxxx>
subject: Create TimeStamp from numeric fields

Hit?send too fast before.

?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?

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