Revision history [back]
 | 1 | initial version |
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).