HUMAN_READABLE_SECONDS
All functions > DATE AND TIME > HUMAN_READABLE_SECONDS
Returns a human readable string from the given number of seconds.
Signatures
Returns: A human-readable string representation of the duration
HUMAN_READABLE_SECONDS(seconds: BIGINT) → INTERVALsql
| Parameter | Type | Required | Description |
|---|---|---|---|
seconds | BIGINT | Yes | The number of seconds to convert |
Notes
- Converts seconds into a readable interval string
- Accepts BIGINT or DOUBLE values
- Useful for displaying durations in a user-friendly format
- Output format depends on the database engine
- Handles large time spans (days, months, years)
On this page