RE: Milliseconds

Then Peter's and Bob's examples should do the trick.  However, since you 
store it in character you'll have to convert it to time first.

If you want you can create a logical file that will do this for you.  Then 
your PC application could download that.

First create a simple RPG service program to convert the character field 
into milliseconds.  Must be a subprocedure in a service program.
Then create a User Defined Function, or UDF, based on this.
Then use SQL to create a view based on this UDF.
For more details you can look at:
http://faq.midrange.com/index.pl?_highlightWords=udf&file=185

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Peter Vidal" <Peter_Vidal@xxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/06/2003 10:52 AM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     RPG programming on the AS400 / iSeries 
<rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: Milliseconds



"C              MyTime   SUBDUR   T'00:00:00'   Mili:*MS"

How big should be "MyTime"?

Peter Vidal
Pall Aeropower Corp.
SR Programmer Analyst
WWW.Pall.com / 727-539-8448, x2414

"A good player makes himself look good; a great player makes the team look
good."
Author unknown


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.