Solved

REPORT BUILDER

Posted on 2009-05-05
2
164 Views
Last Modified: 2012-05-06
I received a filed in the format of seconds, for example 36000 for 10h00m. Does RP have any function to do it?
0
Comment
Question by:jcmotta
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 20 total points
ID: 24306784
Perhaps I am stating the obvious, but cannot you do something like this:
RIGHT(CONVERT(varchar(20), DATEADD(second, 36000, '19000101'), 101), 7)
0
 

Accepted Solution

by:
jcmotta earned 0 total points
ID: 24307134
direct in report buik do not work.
I find it must be STRING(TIME( ), "HH:MM")

Thanks
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
How to increase the row limit in Jasper Server.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question