Need to format to hh:mm:ss

5 pts.
Tags:
SSRS 2000
I'm creating a report in SSRS 2000 and one field reflects time spend on phone daily. However is being displayed as for example, OutboundHours 4818. How can I get this to display in the report as hh:mm:ss. Is there code that I can plug into a variable or syntax that will accomplish this? I don't want to convert from the sql code because in the report I'll need to create groupings with totals. Any light will be appreciated. John

Answer Wiki

Thanks. We'll let you know when a new response is added.

just check up msdn……..there you would be able to out a number of time formats that can be used….

I will give you an example …so lets say the time field your using is GETDATE() (current date)
so apply CONVERT(VARCHAR,GETDATE(),111) …………..and you would get the date in the following format

May 22 2008 11:26PM

The websit i mentioned would really helpful

‘‘Unless man increases in wisdom as much as in knowledge, increase of knowledge will only be increase of sorrow.’’

—Bertrand Russell

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    What does the value 4818 mean? Is that 48 minutes 18 seconds?
    66,115 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following