Eclipse Community Forums: BIRT » Convert integer to time

Home » Archived » BIRT » Convert integer to time(Convert integer or float to time HH:MM:SS)

Convert integer to time [message #1015383]

Thu, 28 February 2013 07:46

Eclipse User

I'm using version 3.2.20 and I wonder how it is possible to transform a field integer or float for hours format
e.g. 94:59:59

Re: Convert integer to time [message #1015453 is a reply to message #1015383]

Thu, 28 February 2013 10:58

Eclipse User

You could do the computations yourself to find the hours, minutes, and seconds. It would be a pretty easy script. Is your integer field in seconds?

Re: Convert integer to time [message #1015457 is a reply to message #1015453]

Thu, 28 February 2013 11:01

Eclipse User

Yes

Re: Convert integer to time [message #1015464 is a reply to message #1015457]

Thu, 28 February 2013 11:13

Eclipse User

If you put something like this into the script of a label, it'll give you the hh:mm:ss breakdown:

temp = 849384;

hours = Math.floor(temp/3600);
temp = temp % 3600;
minutes = Math.floor(temp/60);
if(minutes.length == 1){
minutes = "0" + minutes;
}
seconds = temp % 60;
if(seconds.length == 1){
seconds = "0" + seconds;
}

this.text = hours + ":" + minutes + ":" + seconds;

Previous Topic:	split x-axis label into two lines
Next Topic:	Chart - Modify legend

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Mar 19 23:17:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter