Convert seconds into time format in QM Query

150 pts.
Tags:
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

Answer Wiki

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

Discuss This Question: 4  Replies

 
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
  • BigKat
    is this Query/400 or QM Query? if the later, in the SQL use:
    select  time('00.00.00') + secondsField seconds as timeResult
    7,565 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Dsaran2007
    Sorry i want in QM Query only.
    150 pointsBadges:
    report
  • Dsaran2007
    Many thanks for your help. Sorry for the late response. I got what i need. Once again thanks a lot.
    150 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