Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Date Difference
Migrateduser
<p>Good Day!</p><p> </p><p>I'm just new in using Birt Report and would like to seek for some help form you guys. Im trying to include a column on my birt report (Total Hours Spent). I was able to show the difference of 2 dates but in hours with the querry below:</p><p>SELECT DATEDIFF(HOUR,wo.reportdate,wo.statusdate) ) TotalHourSpent" ->> this will show how many hours</p><p> </p><p>But what i want is to have this kind of format as a result "[color=#ff0000;]<strong>1:12:32:44</strong>[/color]" on my Total Hours Column, so i use the querry below:</p><p> </p><p>" SELECT CONVERT(VARCHAR(15),Datediff(SECOND,wo.reportdate,wo.statusdate)/(60*60*24)) + ':' "<br />
+" +CONVERT(VARCHAR(20),DateAdd(SECOND,Datediff(SECOND,wo.reportdate,wo.statusdate)%(60*60*24),0),108) TotalHourSpent "</p><p> </p><p>Now the problem is, on the 2nd querry, its not showing any records on the preview option, but its working fine in SQL. But if im using the 1st querry it is working just fine on Birt</p><p> </p><p>How you can help me with my concern</p><p> </p><p>Thanks</p>
Find more posts tagged with
Comments
There are no comments yet