FROM_UNIXTIME
All functions > DATE_AND_TIME > FROM_UNIXTIME
Returns a timestamp from the given unix timestamp (BIGINT representation of the number of seconds since 1970-01-01 00:00:00 UTC).
Syntax
FROM_UNIXTIME(unixtime)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
unixtime | BIGINT | Yes | Unix timestamp (seconds since 1970-01-01 00:00:00 UTC) |
Returns
A TIMESTAMP value corresponding to the unix timestamp
Notes
- Converts Unix epoch timestamp to TIMESTAMP
- Input is seconds since January 1, 1970 00:00:00 UTC
- Accepts BIGINT or DECIMAL values
- Useful for converting Unix timestamps from external systems
- Inverse of TO_UNIXTIME