Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
FROM_ UNIXTIME
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