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).

Signatures

Returns: A TIMESTAMP value corresponding to the unix timestamp

FROM_UNIXTIME(unixtime: BIGINT) → TIMESTAMP

Notes

• Converts Unix epoch timestamp to TIMESTAMP
• Input is seconds since January 1, 1970 00:00:00 UTC
• Accepts BIGINT or DECIMAL values
• Always returns UTC; compose with UTC_TO_LOCAL() to present a UTC-stored instant in a named zone
• Useful for converting Unix timestamps from external systems
• Inverse of TO_UNIXTIME

Examples

SELECT
    f1 := FROM_UNIXTIME(1710496200), -- Convert Unix seconds to timestamp
    f2 := FROM_UNIXTIME(0) -- Unix epoch
;