Home > IT Answers > AS/400 > Convert seconds into time format in QM Query
Dsaran2007
150 pts.
 Convert seconds into time format in QM Query
AS/400 Query, AS/400 V6r1m0
I have one scenario where i have time field as seconds and i need to convert this into time format like HH:MM:SS in 24 hour format in query 400. I am using V6R1M0.

Can anyone help me on this ASAP?

Thank in advance

Saravanan D 



Software/Hardware used:
V6R1M0
ASKED: May 24, 2012  9:36 AM
UPDATED: June 1, 2012  10:13 AM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by Dsaran2007 (Question Asker)

is this Query/400 or QM Query?

if the later, in the SQL use:

select  time('00.00.00') + secondsField seconds as timeResult
ANSWERED:  May 24, 2012  1:55 PM (GMT)  by Dsaran2007
 
Other Answers:
Last Wiki Answer Submitted:  December 21, 2012  12:58 pm  by  Dsaran2007   150 pts.
Latest Answer Wiki Contributors:  TomLiotta   110,135 pts. , Dsaran2007   150 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If it’s Query/400, you could create a VIEW that implements BigKat’s suggestion, then query that instead.

But you’d be better off just dropping Query/400 completely and using QM Query.

Tom

TomLiotta
 110,135 pts.
 

Sorry i want in QM Query only.

Dsaran2007
 150 pts.
 

Many thanks for your help. Sorry for the late response. I got what i need. Once again thanks a lot.

Dsaran2007
 150 pts.