erricksandesu
Member
[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
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: