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