FROM_
On this page
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.
-
format: a string containing format symbols as described in DATE_
FORMAT.
Return Type
A datetime object from the timezone set on the cluster.
Examples
SELECT FROM_UNIXTIME(1234567890);
+---------------------------+
| FROM_UNIXTIME(1234567890) |
+---------------------------+
| 2009-02-13 23:31:30 |
+---------------------------+SELECT FROM_UNIXTIME(1234567890, '%M %D, %Y');
+----------------------------------------+
| FROM_UNIXTIME(1234567890, '%M %D, %Y') |
+----------------------------------------+
| February 13th, 2009 |
+----------------------------------------+Related Topics
Last modified: May 31, 2023