Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
FROM_UNIXTIME
Given an integer Unix timestamp, return the corresponding datetime.
Syntax
FROM_UNIXTIME (epoch)
Arguments
- epoch: an integer counting the seconds since 1 Jan 1970 UTC.
Return Type
A datetime object.
Examples
select from_unixtime(1234567890);
+---------------------------+
| from_unixtime(1234567890) |
+---------------------------+
| 2009-02-13 23:31:30 |
+---------------------------+
