Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting to Time Format

Status
Not open for further replies.
H0bbes56

H0bbes56

Programmer
Feb 25, 2009
1
EU
Hi,

I am trying to convert a result I get in seconds into the HH:MM:SS format.
I have tried to modify the item propertieds in the query into datatype TIME and then in the pivot table with the results also into the HH:MM:SS format.
However what I get is not correct; for example, if I originally had a result of 25.577 seconds, after I do this steps I get 00:00:41... The format is correct but the data isn't! It should have turned into 7:06:17.
can any of you help me on this?
Thanks in advance,

Pedro
 
Status
Not open for further replies.

Similar threads

Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
94
Loanpro
Loanpro
sa0309
  • Locked
  • Question
Date Format Conversion
Replies
1
Views
129
rasETL
rasETL
sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
98
sa0309
sa0309
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
2
Views
118
rickeybj
rickeybj
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
0
Views
95
rickeybj
rickeybj

Part and Inventory Search

Sponsor

Back
Top