Outdated Version

You are viewing an older version of this section. View current production version.

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

memsql> select from_unixtime(1234567890);
+---------------------------+
| from_unixtime(1234567890) |
+---------------------------+
| 2009-02-13 23:31:30       |
+---------------------------+