Forum Discussion
Numbers convert into duration
I have number type column, i want to convert those numbers into duration format : 00:00:00. How to do that ? Thanks
In query editor, select the column and the right click on the column and select change type. then you can select duration from there. It can also be completed on the ribbon. You have to do this in query editor.
What does 4356 represent? It looks like it is being evaluated as days. Also, how is it being calculated?
4356 is a number in that duration column. After apply for Duration from Change Data Type, it returns 4356,00:00:00
