nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Time problem

mohanish

Hi Mike

I have a problem and i need some help ... Suppose lets say i have a time as 26 hrs :11 min :07 secs .. what BIRT is doing after changing the date format to HH:mm:ss is 02:11:07 which means 1day 02 hrs :11 min :07 secs but i don't see 1day after using the format HH:mm:ss ..Is it possible to get 26hrs or 1day anyhow or is there any workaround.Please help me out ....

thanks a lot :-)

Find more posts tagged with

Comments

mwilliams

Creating your own string representation of the same would work for this. Or am I missing something?

mohanish

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="85491" data-time="1321650636" data-date="18 November 2011 - 02:10 PM">
Creating your own string representation of the same would work for this. Or am I missing something? </blockquote>
 
 
Hi Mike , 
 
 
I did not get you.How can i change that to a string as i need in in hh:mm:ss format .... what about the hr as it crosses 24.I don't have any problems with mm and ss .

mwilliams

How does this field come into your report? Is it coming from your database or are you taking the difference between two dates within BIRT? Let me know. Also, let me know your BIRT version.

mohanish

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="85546" data-time="1321891924" data-date="21 November 2011 - 09:12 AM">
How does this field come into your report? Is it coming from your database or are you taking the difference between two dates within BIRT? Let me know. Also, let me know your BIRT version. </blockquote>
 
 
let me explain the scenario .... 
 
I have a field which contains the difference of time in seconds.Then I did an aggregate with the column binding name as tot_sec with the SUM option and got the total number of seconds which is fine for me. Then I used your expression given below 
BirtDateTime.addSecond(new Date(0,0,0,0,0,0),row["tot_sec"]) 
with a new data column binding and data type as Date Time. Then I did a Format Date Time on the field where I used the custom option HH:mm:ss. 
 
Now let me explain in figures .. 
 
I get a total secs as 93666 ... upon changing it to HH:mm:ss should give me 26:01:06 but BIRT gives me 02:01:06 ... so that 24hrs is lost. 
 
I use BIRT EUROPA version.

mwilliams

Ok, I understand now. I can explain my explanation further now, knowing how your data comes in. You can create a column that creates a string representation of the same by doing something like:

days = Math.floor(row["tot_sec"]/86400);
temp = row["tot_sec"] - (days * 86400);

Now, you have two options. "temp" contains the seconds left that don't equal a whole day, so you could make a date out of this, format it, then use:

days.toString() + " day(s) " + myDate.toString();

This would give you something like: "1 day(s) 02:01:06"

Or, you could finish figuring out the hours, minutes, and leftover seconds like above and create the entire string yourself.

If you wanted to keep the format 26:01:06, you'd simply not figure the "days" part and start with hours and create your whole string to display.

Hope this helps. Let me know if you have any further questions.

mohanish

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="85638" data-time="1322002304" data-date="22 November 2011 - 03:51 PM">
Ok, I understand now. I can explain my explanation further now, knowing how your data comes in. You can create a column that creates a string representation of the same by doing something like: 
 
days = Math.floor(row["tot_sec"]/86400); 
temp = row["tot_sec"] - (days * 86400); 
 
Now, you have two options. "temp" contains the seconds left that don't equal a whole day, so you could make a date out of this, format it, then use: 
 
days.toString() + " day(s) " + myDate.toString(); 
 
This would give you something like: "1 day(s) 02:01:06" 
 
Or, you could finish figuring out the hours, minutes, and leftover seconds like above and create the entire string yourself. 
 
If you wanted to keep the format 26:01:06, you'd simply not figure the "days" part and start with hours and create your whole string to display. 
 
Hope this helps. Let me know if you have any further questions. </blockquote>
 
 
BIRT GURU you are a real GURU ...thank u so much ... It solved my problem ... again thanks a lot :-)

mwilliams

You're welcome! Let us know whenever you have questions!