|
Hi,does it mean, you want to have the difference between 2 times as numeric value in the format HHMMSS, and the difference between two dates as numeric value in the format YYYYMMDD and the difference between 2 timestamps as numeric value in the format YYYYMMDDHHMMSS,MicroSec?
If so just use embedded SQL. Enbedded SQL will calculate time/date and timestamp differences in this way. i.e. the difference between 8:00 AM and 10:30 AM will be returned as 23000 (if you only want 230 just divide throuhg 100)
C/EXEC SQL Set :MyNumDiff = :MyTime1 - :MyTime2 C/End-Exec Mit freunlichen Grüßen / Best regards Birgitta Hauser"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)----- Original Message ----- From: "Willie J. Moore" <WMoore@xxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> Sent: Monday, December 04, 2006 20:15 Subject: RE: convert time to hundreds
Alan, Yes.The differents between two time (1:00pm and 2:02pm) would be 1 hour 2 minutes. What I need or would like would be it to be 102. This would allow me to multiply the hourly wage by this figure to get cost.Willie.. -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Alan Shore Sent: Monday, December 04, 2006 11:03 AM To: RPG programming on the AS400 / iSeries Subject: Re: convert time to hundreds Willie - could you please expand on what your definition of "hundreds" is? Hours? minutes? seconds? etc. Alan Shore NBTY, Inc (631) 244-2000 ext. 5019 AShore@xxxxxxxx rpg400-l-bounces@xxxxxxxxxxxx wrote on 12/04/2006 01:55:24 PM:I have a need to convert the difference between two times into hundreds. This is so we can calculate the cost for job costing. I have used the *H, *MN options. Is there one for hundreds? I have done this in RPGIII. But it requires a lot of calculation. If not, can I get an example of a better way to do this. Thanks, William Moore -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailinglistTo 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.-- 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. -- 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
