I need a SQL query to convert 130 minutes into HH:MM:SS format. Can you send me the query to do this please.

    Requires Free Membership to View

    Login

Sorry, but the answer is "It depends."

In MySQL, you can say sec_to_time(130*60) and you're done.

In Microsoft SQL Server, you can say convert(char(8),dateadd(n,130,0),108) and you're done.

In Microsoft Access, you can say format(dateadd("n",130,0),"HH:NN:SS") and you're done.

None of these SQL snippets will work in any other database.

Sorry, off the top of my head I don't know how to do this in Oracle, Informix, DB2, Firebird or PostgreSQL. I would have to look up the date and time functions in the manual, to see if I can find any that might be of service. But you can do that too, eh.

This was first published in March 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top