HUMAN_READABLE_SECONDS
All functions > DATE_AND_TIME > HUMAN_READABLE_SECONDS
Returns a human readable string from the given number of seconds.
Syntax
HUMAN_READABLE_SECONDS(seconds)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
seconds | BIGINT | Yes | The number of seconds to convert |
Returns
A human-readable string representation of the duration
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)