Re: Convert character field representing time to numeric

Hi Dave,

if you have a char field containing i.e ‘12:35:56’ you can convert this into a decimal with:

numTime = %dec(%time(charTime:*hms):6:0);

If you are not sure, if that string in fact contains a valid “time” (and not something like ‘25:67:99’) then you should wrap that like in a monitor group and handle possible errors.

So this line will not only convert, it will also test if the time value is valid.

If you don’t want to test it, try to just remove the colons from that string and convert it - like this:

numTime = %dec(%scanrpl(‘:’:’’:charTime):6:0);

HTH
Daniel

Am 25.10.2022 um 21:35 schrieb Dave <dfx1@xxxxxxxxxxxxxx>:

Hi,

Receiving time data from XML in HH:MM:SS format and need numeric HHMMSS.

Just starting out with the XML-INTO command.
Reading the time data into a data structure character field (I think this
is obligatory).

How can I get the time in the required format without doing daft
manipulations?

I have the same problem with the dates but
MyField = %DEC(%DATE(characterDate))
works.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com