In Google Looker Studio, what is the method for converting seconds to a duration format displayed as minutes and seconds (mm:ss)?

edit

The method for converting seconds to a duration format displayed as minutes and seconds (mm:ss) in Google Looker Studio is to use the DATE_TRUNC function with the SECOND interval and format it using the FORMAT_DATE function. Here's an example:

SELECT FORMAT_DATE('%M:%S', DATE_TRUNC('SECOND', TIMESTAMP_SECONDS(1234)))

This will convert the number of seconds (1234) to a duration format displayed as minutes and seconds (20:34).