• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Time Convesion

[Solved] Time Convesion

Dear All,

anyone knows business function to quickly convert time.

The example is like:

My table has TDAY with content:
9 means "00:00:09"
30 means "00:00:30"
123 means "00:01:23"
3350 means "00:33:50"
93429 means "09:34:29"
235500 means "23:55:00"

If possible, i don't want to use the "if - lenght - substr - concat" way, it's too long.

So anyone knows a business function to do that? OR any short way to do that.

Thank you very much

=============================edit by Me 07/11/19

I user B9800188


Thanks all
Last edited: