How to Convert Seconds to Minutes and Hours in Bold BI

In Bold BI, it is possible to convert seconds to minutes and hours using expressions. This can be done for various data sources including MySQL and MongoDB.

MySQL

In MySQL, the SEC_TO_TIME() function is used to convert seconds to a time value. The syntax is as follows:

SEC_TO_TIME([column_name])

MongoDB

In MongoDB, the TO_CHAR() function is used to convert seconds to a time value. The syntax is as follows:

TO_CHAR(([column_name] || ' second')::interval, 'HH24:MI:SS')

Conclusion

Converting seconds to minutes and hours in Bold BI is a straightforward process. By using the appropriate expressions for your data source, you can easily transform your data to better suit your needs.

References

• MySQL Official Documentation
• MongoDB Official Documentation