topic Re: Display the time in a different format in Application Development and Automation Discussions

Display the time in a different format

former_member723329 — Fri, 26 Feb 2021 08:09:25 GMT

Hey Guys,

I have an ALV where i output some time fields from cr02. Now it looks like this: 19.800 but i need it like this: 00:00:00

How can i do it on a very easy way?

Kind regards

Mario

Re: Display the time in a different format

FredericGirod — Fri, 26 Feb 2021 08:50:03 GMT

You will need to provide part of your code, especialy the field catalog

Re: Display the time in a different format

former_member723329 — Fri, 26 Feb 2021 09:01:00 GMT

Hello

This is my type structure.

the data type is tims.

I select this fields from the table into the fields of my table.

Now i want to change this fields, so that they look like format 00:00:00

Re: Display the time in a different format

Sandra_Rossi — Fri, 26 Feb 2021 09:09:18 GMT

In the catalog, uUse the type D for dates (or DATS), not a numeric type like I, P, etc. (or INT4, DEC, etc.) Or indicate a field or a data element which refers to such a type.

Re: Display the time in a different format

Sandra_Rossi — Fri, 26 Feb 2021 09:11:47 GMT

And how does your field catalog look like?

Re: Display the time in a different format

former_member723329 — Fri, 26 Feb 2021 09:28:29 GMT

Hello Sandra Rossi,

I output the alv like this. alv.png

so i think the output is like the fields from my types

Re: Display the time in a different format

FredericGirod — Fri, 26 Feb 2021 09:46:24 GMT

But it is not a time, it is a number of second.

you have to play with it before display it:

could be something like that (I don't test the code)

data(hour) = time DIV 3600.
data(remaining_time) = time - (hour * 3600 ).
data(minut) = remaining_time div 60.
data(second) = remaining_time - ( minut * 60 ).
result = |{ hour }{ minut }{ second }|.

Re: Display the time in a different format

former_member723329 — Fri, 26 Feb 2021 10:45:11 GMT

thank you i will try it this way

Re: Display the time in a different format

Sandra_Rossi — Fri, 26 Feb 2021 19:55:00 GMT

You'd better avoid indicating the important part of the question in a separate image. The 3 fields concerned are:

KAKO-BEGZT (Start time in seconds (internal))
KAKO-ENDZT (Finish time in seconds (internal))
KAKO-PAUSE (Cumulative break time in seconds (internal))

19,800 means 19800 seconds = 5 hours and a half

Re: Display the time in a different format

RaymondGiuseppi — Mon, 01 Mar 2021 10:46:46 GMT

Did you try to define some fields with a TIMS / T data type. With implicit conversion adding your integer fields in seconds to an initial time field will provide the expected result (just check for overflow)

Re: Display the time in a different format

former_member723329 — Tue, 02 Mar 2021 13:44:11 GMT

ty sandra.rossi