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
sql
ParameterTypeRequiredDescription
unixtimeBIGINTYesUnix timestamp (seconds since 1970-01-01 00:00:00 UTC)

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
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19