Solved

REPORT BUILDER

Posted on 2009-05-05
2
158 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql Query Lookup based on range 2 29
Oracle PL/SQL syntax 4 52
SQL query syntax with WHERE and '%[ABC' clause 1 29
query question 13 41
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now