SingleStore DB

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.

  • format: a string containing format symbols as described in DATE_FORMAT.

Return Type

A datetime object.

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                    |
+----------------------------------------+